Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 High Availability (2005)
 SQL 2005 Failover Cluster Installation

Author  Topic 

dbthj
Posting Yak Master

143 Posts

Posted - 2008-05-02 : 12:08:49
I noticed in installing a SQL2005 failover cluster instance,that it is not necessary to install on both servers. Installing on the primary node automagically installs to the secondary node. Does this constitute a COMPLETE install? It all seems to work. BUT this process does not intall client pieces (SSMS, for instance) on the secondary node. If you want that stuff there, do you then go to that box and just do a client install?

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-05-02 : 14:05:00
That's how clustering works for software packages that are cluster aware. The client tools are not cluster aware, so you must install on each node if you want the tools on each node.



Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Database maintenance routines:
http://weblogs.sqlteam.com/tarad/archive/2004/07/02/1705.aspx
Go to Top of Page

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-05-03 : 20:14:10
And ssis is not cluster aware either.
Go to Top of Page
   

- Advertisement -