SQL Server 2005 COM + catalog requirements warning
①. Start Distributed Transaction Coordinator service
Open the service, find the Distributed Transaction Coordinator service in the service, select "Properties";
In the "Login" tab, select "This account", the account name is filled with "NT authority/networkservice", the password is empty;
Restart the service after clicking OK.
Alternatively, run Msdtc-uninstall under the command line to uninstall the MSDTC service;
Run Msdtc-install again to install the MSDTC service.
The MSTDC service started successfully, and COM + applications in the component service are accessible.
If you also encounter distributed Transaction Coordinator service cannot start error: Distributed Transaction Coordinator service due to 3221229584 (0xC0001010) A service error has been stopped. This solves:
Click start → run → enter command "msdtc-resetlog" to run the command.
② Follow these procedures to reinstall COM +
Installing the Component Services snap-in
On the Windows desktop, click Start, and then click Run.
In the Open box, 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-in, and then click Add.
Click Close to close the Add Standalone Snap-in window, and then click OK to close the Add/Remove Snap-in window.
In the Console root node/Component Services window, expand the Component Services tree. This is where the error message can occur when there is a problem with COM +.
Run the SQL Server 2005 Setup program again. If you receive an error message, reinstall COM +.
Reinstall COM +
From Add or Remove Programs in Control Panel, click Add/Remove Windows components.
In the Windows Components Wizard, do not make any changes to the selection and click Next.
Always click to complete the wizard, and then run the SQL Server 2005 Setup program again.
After resolving the COM + problem, the following "Detect installed IIS services" Suspended animation phenomenon also resolved.
Of course, the process of solving the problem of the same system environment is not the same, here to talk about my installation of small setbacks, I hope to meet the same problem friends have some hint.
If the above method still does not solve the problem, then please create a new. bat file, the code is as follows:
@echo off
Setlocal
@echo%windir%/system32/msdtc.exe-uninstall
%windir%/system32/msdtc.exe-uninstall
Call:d Elkey "Hkcr/cid"
Call:d Elkey "HKLM/SYSTEM/CURRENTCONTROLSET/SERVICES/MSDTC"
Call:d Elkey "HKLM/SYSTEM/CONTROLSET001/SERVICES/MSDTC"
Call:d Elkey "HKLM/SYSTEM/CONTROLSET002/SERVICES/MSDTC"
Call:d Elkey "HKLM/SOFTWARE/MICROSOFT/MSDTC"
@echo%windir%/system32/msdtc.exe-install
%windir%/system32/msdtc.exe-install
Endlocal
Goto:eof
:d Elkey
Set key=%1
Call:d elkeyq%key% >nul 2>&1
@echo.
Goto:eof
:d Elkeyq
REG DELETE%key%/F
This article is from the "Freeterman" blog, make sure to keep this source http://myunix.blog.51cto.com/191254/1751340
Install SQL2005 prompt for "SQL Server 2005 COM + catalog Requirements" Warning workaround