SQL Server 2005 installation Failure processing method

　　Error Case: There was a problem installing the SQL Server 2005 Enterprise Edition of the MSDN subscription download on Microsoft Virtual PC 2007 and a portable computer. The installation environment is Windows Server 2003 Enterprise Edition + SP1, and another system is SP2, and the installation user uses the Super Administrator (the Administrator). An installation error occurred while installing the "Integration Services" step, prompting "error:-2146233087".
　　The error records are as follows:

Title: Microsoft SQL Server 2005 Setup

------------------------------

Unable to install and configure assembly C:\Program Files\Microsoft SQL Server\90\dts\tasks\microsoft.sqlserver.msmqtask.dll in the COM + catalog. Error:-2146233087

Error message: Unknown error 0x80131501

Error description: To perform this task, you must have administrative credentials. Please contact your system administrator for assistance.

　　For help information, click:

Go.microsoft.com/fwlink?linkid=20476&prodname=microsoft

+sql+server&prodver=9.00.1399.06&evtsrc=setup.rll&evtid=

29549&evttype=sqlca%5csqlassembly.cpp%40do_sqlassemblyreg

svcs%40do_sqlassemblyregsvcs%40x80131501

Through the hyperlink page for help information, the prompt "needs to be run for the MS DTC service configuration Network Service account", but the author's MS DTC is originally running under the Network Service account.

Through Baidu and Google search for a while, many friends encountered similar error message, but did not get a good solution, had to find clues to try. It is certain that the problem should appear in the access rights, and the common problems in this area are generally access to the file system directory and the system registry. Search for installation information for SQL Server in Microsoft's customer Help and Support website. One article mentions the right to set "C:\WINDOWS\Registration", confirming that the directory and the CLB and Crmlog files in the directory have full read and write access, and install SQL Server 2005 again in the "Integration Services" The step still prompts for failure. Using the built-in system account or using a domain user account is the same when selecting a service account during Setup.

It seems that the problem is not so simple, the author in another system when installed on the Regmon to perform registry operation monitoring, filtered only to monitor the "msiexec.exe:484" process, in the report with the above mentioned errors to save the monitoring log to the file.

View the failed situation through the monitoring log. Due to the lack of careful search, later, the Microsoft SQL Server Group of technical support engineers to think of the problem should be resolved early. Here's what I looked up again at the problem point of Regmon trace Discovery, which is shown in the following log to access the registry using the native administrator. hkcr\ Microsoft.SqlServer.Dts.Tasks.MessageQueueTask.DataFileMessage item was rejected.

11305 32.35072327 msiexec.exe:484 Openkey hkcr\microsoft.sqlserver.dts.tasks.messagequeuetask.datafilemessage ACCESS DENIED Nbcn-zz\administrator

11306 32.36096954 msiexec.exe:484 querykey hkcu\software\classes SUCCESS Name: \registry\user\ S-1-5-21-730333180-4162487032-3015738926-500_classes

11307 32.36102295 msiexec.exe:484 Openkey hkcu\software\classes\ Microsoft.SqlServer.Dts.Tasks.MessageQueueTask.DataFileMessage not FOUND

11308 32.36108017 msiexec.exe:484 openkey HKCR SUCCESS

11309 32.36190796 msiexec.exe:484 CreateKey hkcr\microsoft.sqlserver.dts.tasks.messagequeuetask.datafilemessage ACCESS DENIED Nbcn-zz\administrator

11310 32.36222076 msiexec.exe:484 CreateKey hkcr\microsoft.sqlserver.dts.tasks.messagequeuetask.datafilemessage ACCESS DENIED Nbcn-zz\administrator

Due to careless results and a lot of work to see the system's "Component Services" configuration is a problem, but did not find anything unusual.

After the installation problem again, click the "Ignore" button to continue to install the other parts of SQL Server, after the installation completes, prompts the installation to complete successfully.

Run "DCOMCNFG" to open system Component Services. Expand Console Root-> Component Services-> computer-> My Computer->com+ application node, no Microsoft.SqlServer.MSMQTask node was found, it is visible that the COM + application is not installed.

Run SQL Server 2005 Setup again to add a delete installation, prompting for a successful installation and seeing "Microsoft.SqlServer.MSMQTask" in Component Services. It seems that the problem has been solved, but then I don't know what the problem is. Uninstall SQL Server 2005 and discover that "Microsoft.SqlServer.MSMQTask" is not uninstalled and that the test installs only the Integration Services service for SQL Server 2005. The result installation failed, select Abort to cancel the installation, and reconfirm the presence of the "Microsoft.SqlServer.MSMQTask" service.

Then I sent the error of the installation process to Microsoft, ask the Technical support Engineer of SQL Server group to help solve. In the process of finding an engineer, although I have done many checkpoints, but he has a clear idea of how to solve the problem, I have outlined a few steps below.