How to solve the problem that the COM + System Configuration check in the SQL Server Installation program fails?

Source: Internet
Author: User
Tags microsoft sql server 2005

The Microsoft SQL Server 2005 installer checks whether COM + is correctly configured. If a configuration error is found, the installer continues, but the following warning is displayed in the System Configuration check (SCC) report:

"If the SQL Server installation fails, the installation will roll back the installation, but may not delete all. manifest files. The solution is to rename these files and run the installer again ."

If Microsoft Distributed Transaction Coordinator (ms dtc) is not running, or if ms dtc is not a cluster resource when Microsoft Cluster Server is used, a COM + error may occur. COM + depends on ms dtc, while Message Queue tasks in Integration Services depend on COM +. If a COM + error occurs, the Message Queue task in Integration Services is available only after the COM + system is correctly configured.

To use a message queue, also known as MSMQ), ensure that the ms dtc is running and configured correctly. If SQL Server is installed on a cluster, MS DTC must be a cluster resource.

Reinstall COM + as follows.

Install Component Service Management Unit

1. on the Windows desktop, click Start and then click Run ".

2. In the open box, type MMC and click OK ".

3. In the "console" window, click "Files" on the menu bar, and then click "Add/delete snap-in ".

4. In the Add/delete snap-in window, click Add ".

5. In the "add independent management unit" window, select "component service" from the management unit list and click "add ".

6. Click Close to close the add independent unit window, and then click OK to close the Add/delete unit window.

7. In the "Console Root Node \ component service" window, expand the "component service" tree. This is where the error message may occur when a problem occurs with COM +.

8. Run the SQL Server 2005 installation program again. If you receive an error message, reinstall COM +.

Reinstall COM +

1. Click Add/Remove Windows Components from add or remove programs on the control panel ".

2. In the "Windows component wizard", do not make any changes to the selection, and click "Next ".

3. Click until the Wizard is completed, and then run the SQL Server 2005 installation program again.

Original article address

View more articles

Edit recommendations]

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.