Management studio is not instaaling on Node2 in a cluster..

  • I installed sql server 2005 in a active/passive cluster setup.I installed from node 1(Active) and I also selected Client tools to install. Installation is done and applied SP3 successfully.Now, Management studio is installed on node1 only. It did not install on node2? Is this normal behavior? What should I do to install management studio on Node2 also?

    thanks

  • This is normal behaviour.

    Only SQL database engine & analysis services are cluster aware SQL component i.e means the related data files is installed on shared drive and binary files is installed on both the nodes.

    All other components like reporting, notification, workstation(mgmt studio) are not cluster aware component and is installed on the active node.

    To install workstation go to add/remove programs, select SQL 2005. there is an option to install new component, point of SQL installation files, select only workstation component and install it...

    BR,

    Parthi

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply