SQL Server Management Studio in SQL Server 2005 Cluster
-
Hi,
I have craeted SQL server 2005 2 node active-passive cluster and I have following query.
I have installed SQL Server Management Studio on node 1 only.
When owner of my cluster resources is node 2 how can I create a database from node 1 using SQL Server Management Studio?
On node 1 SQL services are stopped and shared data disk is also not accessible as node 2 is the owner.
Can anyone answer this?
Thanks,
RajanW
-
Yes. Just connect using the Virtual Name.
-
I suggest you also install the client tools on Node2. This way you will have a working client if Node1 is down.
Our Cluster Install standard is that following an install of SQL to the cluster, we then go to all the other nodes to install the non-clustered components. In this way all of the nodes are peers as far as the software mix is concerned.
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
-
As far as I know you should also install Integration Services on the 2 node. Otherwise in case of a failover the maintenance plans are not going to work.....just in case you have some
-
You can always cluster SSIS -
http://sqljunkies.com/WebLog/knight_reign/archive/2005/07/06/16015.aspx
Tommy
Tommy
Follow @sqlscribe -
Sorry, I was not very precise on my post. Of course you can cluster SSIS, but you should install it on both nodes, to be sure it works.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply