MSDTC COM+ MS SQL 2005
1115 今天又出新问题:安装 SQL 2005的时候,报告 COMPLUS 出现一个警告
要我看
How to: Work Around COM+ System Configuration Check Failure in SQL Server Setup
http://msdn2.microsoft.com/en-us/library/ms143690.aspx
To install the Component Services snap-in
From the Windows desktop, click Start and then click Run.
In Open, type MMC, and then click OK.
In the Console window, click File on the menu bar, and then click Add/Remove Snap-in.
In the Add/Remove Snap-in window, click Add.
In the Add Standalone Snap-in window, select Component Services from the list of snap-ins, and then click Add.
Click Close to close the Add Stand-alone Snap-in window, and then click OK to close the Add/Remove Snap-in window.
In the Console Root\Component Services window, expand the Component Services tree. This is where any error message would occur if there was a problem with COM+.
Run SQL Server 2005 Setup again. If you get an error message, reinstall COM+.
To reinstall COM+
From Add or Remove Programs in Control Panel, click Add/Remove Windows Components.
In the Windows Components Wizard, click Next without making any selection changes.
Click through to complete the wizard, and then run SQL Server 2005 Setup again.
结果问题依旧,跑到服务那里启动 Distributed Transaction Coordinator 协调跨多个数据库、消息队列、文件系统等资源管理器的事务。
结果热闹了:
Distributed Transaction Coordinator 服务因 3221229584 (0xC0001010) 服务性错误而停止
MS DTC 跟踪结构: 跟踪结构的初始化失败。内部信息: msdtc_trace : File: d:\srvrtm\com\complus\dtc\dtc\trace\src\tracelib.cpp, Line: 1107, StartTrace Failed, hr=0x80070005
找不到 MS DTC 日志文件。在确认所有由 MS DTC 协调的资源管理器不具有“不确定”状态的事务之后,请运行 msdtc -resetlog 创建日志文件。
MS DTC 事务管理器启动失败。LogInit 返回错误 0x5。
无法启动 MS DTC 事务管理器。
The clustered MSDTC resource fails when you change the PDC Emulator operations master role to a different node in the cluster on a computer that is running Windows Server 2003
http://support.microsoft.com/?kbid=900216
1. Click Start, click Run, type regedit, and then click OK.
2. Locate and then right-click the following registry subkey:
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Service\Cluster\Resources\<MSDTC resource GUID>
3. Click Permissions, and then click NETWORK SERVICE.
4. In the Allow column of the Permissions for NETWORK SERVICE box, click to select the Full Control check box, and then click OK.
结果根本找不到这个键值
The Microsoft Distributed Transaction Service Does Not Start and Error 3221229584 Is Logged
http://support.microsoft.com/default.aspx?scid=kb;en-us;205069
Windows 2000
To resolve this behavior on a Windows 2000-based computer, use one of the following methods, as appropriate for your situation.
Method 1
1. Create a new Microsoft Management Console (MMC): a. Click Start, click Run, type mmc, and then click OK.
b. When MMC opens, on the Console menu, click Add/Remove Snap-in, and then click Add.
c. Click Component Services, click Add, and then close the window.
d. Click OK on the Add/Remove Snap-in dialog box.
2. Expand Component Services, and then in the Computers node, right-click the computer that is generating the error, which is usually My Computer, and then click Properties.
3. On the Advanced tab, the location of the log file, Msdtc.log, should be %SystemRoot%\System32\Dtclog. If this is not the location that is indicated, use the Drive and Directory controls to specify this location.
4. Click Reset Log.
5. Start the MSDTC service.
Method 2
1. Rename the %SystemRoot%\System32\Dtclog folder to Dtclog.old.
2. Create a new Dtclog folder in the same location (%SystemRoot%\System32\Dtclog).
3. At a command prompt, type the following, and then press ENTER:
MSDTC -resetlog
4. Start the MSDTC service.