Article ID: 940971 - View products that this article applies to.
You cannot install a Microsoft SQL Server 2005 service pack, hotfix, or cumulative update. When this issue occurs, an error message that resembles the following is logged in the Summary.txt file:
Note The Summary.txt file is located in the %ProgramFiles%\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix folder.
Machine : server_name
Additionally, an error message that resembles the following is logged in the SQLTools9_Hotfix_KB921896_sqlrun_tools.msp.log file:
Note The SQLTools9_Hotfix_KB921896_sqlrun_tools.msp.log file is located in the %ProgramFiles%\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix folder.
MSI (s) (9C!38) [17:51:18:649]: Product: Microsoft SQL Server 2005 Tools -- Error 29549. Failed to install and configure assemblies C:\Program Files\Microsoft SQL Server\90\NotificationServices\9.0.242\Bin\microsoft.sqlserver.notificationservices.dll in the COM+ catalog. Error: -2146233087
This issue occurs if the SQL Server Setup program cannot access the Microsoft Distributed Transaction Coordinator (MSDTC) service.
To resolve this issue when SQL Server 2005 is installed on Windows Server 2008 R2, use one of the following methods.
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
For more information about how to securely enable network access for the MSDTC service, visit the following Microsoft TechNet website:
For more information about how to modify the default MSDTC resource in Windows Vista or in Windows Server 2008, visit the following Microsoft TechNet website:
http://technet.microsoft.com/en-us/library/cc742418.aspxFor more information about how to enable firewall exceptions for the MSDTC service, visit the following Microsoft TechNet website:
http://technet.microsoft.com/en-us/library/cc725913.aspxFor more information about how to configure authentication options in the Security Configuration tab of MSDTC, click the following article numbers to view the articles in the Microsoft Knowledge Base:
Article ID: 940971 - Last Review: May 7, 2012 - Revision: 5.0
Contact us for more help
Connect with Answer Desk for expert help.