faliover
-
i have two servers a and b
both are active- passive envi.
a - is the primary
b - secondary
a - shows sql server
b - It shows sql server , it does not show manegment studio .
any help !
-
I want to know if I understood your problem:
You have an active/passive cluster. After you did a failover you are missing management studio on the other server. Is that your problem?
-
yes
-
Try to type 'sqlwb' ( for SQL 2005), or 'ssms' (for SQL2008) in Start-->Run on the server where you think it's missing. and see what happens.
-
It says it cannot find sqlwb .
-
Do you remember if ssms was installed?
Have you worked on the server earlier using the ssms?
Bru MedishettyBlog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
-
Are you able to use SQLCMD?
-
As far as I am aware SSMS is not cluster aware and you have to do a separate install of the workstation components on the second node.
you don't need to failover to do this.
---------------------------------------------------------------------
-
George is right, when you install SQL on cluster work station components gets installed only on active node, you have to install work station components on other node if you need it.
EnjoY!
EnjoY! -
Or you can install the client components on your desktop computer. This has the following advantages:
(1) You're not logged on to the server and stopping someone who needs to log on to do some maintenanace from connecting;
(2) There's less risk of accidentally changing something on the computer;
(3) You can manage all your servers from the same place.
John
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply