Please help with Missing Management Studio in second node.

Giganews Newsgroups
Subject: Please help with Missing Management Studio in second node.
Posted by:  Windows W2K3 User (WindowsW2K3Us…@discussions.microsoft.com)
Date: Tue, 18 Dec 2007

Hello, everyone.

I installed a 2-node SQL 2005 Standard Edition with SP2 cluster
(active/passive).
I realized that the Management Studio was not installed on the 2nd node.
How do I fix this issue without breaking my cluster in production mode
already? This is very critical for me to get it right in one shot.

Please advise.

P.S: I can't believe MS SQL server team did not catch this in their QA.
Additionally, I had other issue during the SQL cluster forcing me to redo the
installation from scratch several times. SQL 2000 was more "stable" than
2005? I was hoping that SQL 2005 much much better off than 2000 with the big
investment spent on it and touting as the best one ever ..................

Replies