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

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]