Wednesday, March 28, 2012

installing management studio on a cluster

Hi,
I am installing sql 2005 on a two node cluster. I have managed to complete
the installation and then wanted to add the sql management studio on to the
cluster. I installed disk two and chose the support tools but have way
through the installation it failed with the following error:
Failed to install and configure assemblies C:\Program Files\Microsoft SQL
Server\90\NotificationServices\9.0.242\Bin\microso ft.sqlserver.notificationservices.dll in the COM+ catalog. Error: -2146233087
Error message: Unknown error 0x80131501
Error description: The Transaction Manager is not available. (Exception from
HRESULT: 0x8004D01B)
I was installing this on the first node which had ownership of the shared
disks
Any ideas
Looks like you need to install a clustered instance of MSDTC.
http://www.microsoft.com/technet/prodtechnol/biztalk/2006/library/bts06clustering/55b0c81f-44a5-4069-b065-57df1cce19ac.mspx?mfr=true
Ignore the incoming caller stuff. That is for Biztalk.
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP
"Paul" <Paul@.discussions.microsoft.com> wrote in message
news:D07341A6-EDDA-4448-9C8A-23A1727E565B@.microsoft.com...
> Hi,
> I am installing sql 2005 on a two node cluster. I have managed to complete
> the installation and then wanted to add the sql management studio on to
> the
> cluster. I installed disk two and chose the support tools but have way
> through the installation it failed with the following error:
> Failed to install and configure assemblies C:\Program Files\Microsoft SQL
> Server\90\NotificationServices\9.0.242\Bin\microso ft.sqlserver.notificationservices.dll
> in the COM+ catalog. Error: -2146233087
> Error message: Unknown error 0x80131501
> Error description: The Transaction Manager is not available. (Exception
> from
> HRESULT: 0x8004D01B)
> I was installing this on the first node which had ownership of the shared
> disks
>
> Any ideas

No comments:

Post a Comment