Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
DB Engine
SQL ServerMSDESQL Server CE
Services
Analysis (Data Mining)Analysis (OLAP)DTSIntegration ServicesNotification ServicesReporting Services
Programming
CLRConnectivitySQLXML
Other Technologies
ClusteringEnglish QueryFull-Text SearchReplicationService Broker
General
Data WarehousingPerformanceSecuritySetupSQL Server ToolsOther SQL Server Topics
DirectoryUser Groups
Related Topics
MS AccessOther DB ProductsMS Server Products.NET DevelopmentVB DevelopmentJava DevelopmentMore Topics ...

SQL Server Forum / Other Technologies / Clustering / March 2006

Tip: Looking for answers? Try searching our database.

SQL 2005 Cluster install - Management Studio missing on second nod

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Drinian - 11 Mar 2006 21:27 GMT
Hey All,

I've tried this a couple of times and I keep getting the same result...  
When I install SQL 2005 Std it only installs the SQL Management Studio and
most of the client tools on the actual node that I'm running setup.exe from.  
The SQL Server works on both nodes but I cannot manage from the second node.

When I try to install the Management components on the 2nd node it tells me
that they are already installed.  I've uninstalled and started over from
scratch multiple times and it always behaves exactly the same.

I think I've got a pretty basic configuration... 2 node active/passive
cluster...

Anyone have any ideas?

Thanks!
Lukas - 23 Mar 2006 14:09 GMT
Try to Terminal into the VIRTUAL server, have a look if the Management Studio
is installed. Failover to the second node and see if you can still access the
Management Studio.

> Hey All,
>
[quoted text clipped - 13 lines]
>
> Thanks!
Geoff N. Hiten - 23 Mar 2006 16:47 GMT
That is a known issue.  Check the ReadMe file on the SQL CD.  SQL Client
tool installs are not cluster-aware and only install to the local node..

Signature

Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP

> Hey All,
>
[quoted text clipped - 16 lines]
>
> Thanks!
Drinian - 23 Mar 2006 17:51 GMT
The problem wasn't that the tools weren't installed by default, the problem
was that when I went to the 2nd node to manually install the tools they
refused to install (saying that the tools were already installed).  

I ended up having to delete the "tools" directory on the 2nd node (which
didn't really have anything in it but was created by setup) and then I was
finally able to install the tools on that node.

> That is a known issue.  Check the ReadMe file on the SQL CD.  SQL Client
> tool installs are not cluster-aware and only install to the local node..
[quoted text clipped - 19 lines]
> >
> > Thanks!
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.