Install SQL2005 prompt for "SQL Server 2005 COM + catalog Requirements" Warning workaround

Source: Internet
Author: User

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

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.