Error Displayed in Summary.txt after installation:
MSP Error: 29549 Failed to install and configure assemblies D:\MSSQL_Tools (x86)\90\NotificationServices\9.0.242\Bin\microsoft.sqlserver.notificationservices.dll
MSDTC Event ID: 4384
http://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=2036880&SiteID=17
Checked cluster admin, and sure enough it is not there. You need to register MSDTC as a cluster resource, and then restart setup.
This is known issue, where client tool upgrades will not work unless the Distributed Transaction Coordinator is registered in the MSCS cluster (even if the SQL Engine is not installed)
How to configure Microsoft Distributed Transaction Coordinator on a Windows Server 2003 cluster
http://support.microsoft.com/kb/301600/
How to enable network DTC access in Windows Server 2003
http://support.microsoft.com/kb/817064/
I am related to Software Industry working as SQL Database Administrator, so I have created this blog to collect useful information about my area of work. It may contains references to stuff published somewhere else on internet [with full regards to the publisher, of course] and also some of my own. I will also post some out of the box stuff too, if I find it interesting.
No comments:
Post a Comment