Installing a local instance of SQL on a Cluster Node

Installing a local instance of SQL on a Cluster Node

Post by tjbeaumon » Fri, 06 Oct 2006 17:29:15


Hi

I have an Active/Passive SQL 2000 Cluster - the OS is W3K Server.

I would like to install a local copy of SQL Server on the node that is
currently passive - if I start the SQL install process, it does give me
this option but I don't know what, if any, problems this might cause.

I appreciate if the currently active node fails, it will failover to
the node which also has a local version running as well.

Has anyone done this? I've tried searching groups and Microsoft without
success.

Thanks

Toby
 
 
 

Installing a local instance of SQL on a Cluster Node

Post by Tom Morea » Fri, 06 Oct 2006 20:16:46

It's OK to install local instances on cluster nodes. Just make sure the
instance name does not conflict with any instance on the cluster.

--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
.


Hi

I have an Active/Passive SQL 2000 Cluster - the OS is W3K Server.

I would like to install a local copy of SQL Server on the node that is
currently passive - if I start the SQL install process, it does give me
this option but I don't know what, if any, problems this might cause.

I appreciate if the currently active node fails, it will failover to
the node which also has a local version running as well.

Has anyone done this? I've tried searching groups and Microsoft without
success.

Thanks

Toby

 
 
 

Installing a local instance of SQL on a Cluster Node

Post by Russ Kaufm » Fri, 06 Oct 2006 23:48:56


Yes, you can do it, but it is a violation of the HA spirit. Meaning, why in
the world would you want to *** around and do that when the company has
obviously felt that the other SQL instances (in the cluster) require HA?
Don't mess with the HA environment!


--
Russ Kaufmann
MVP - Windows Server - Clustering
ClusterHelp.com, a Microsoft Certified Gold Partner
Web http://www.yqcomputer.com/
Blog http://www.yqcomputer.com/
 
 
 

Installing a local instance of SQL on a Cluster Node

Post by TGluY2hpIF » Sat, 07 Oct 2006 02:08:01

That's true for production clusters. But we install standalone SQL instances
on a clustered node all the time on our test clusters.

Linchi
 
 
 

Installing a local instance of SQL on a Cluster Node

Post by Russ Kaufm » Sat, 07 Oct 2006 03:07:16


So, your test environment doesn't mirror production? :)

Actually, I can see doing that.


--
Russ Kaufmann
MVP - Windows Server - Clustering
ClusterHelp.com, a Microsoft Certified Gold Partner
Web http://www.yqcomputer.com/
Blog http://www.yqcomputer.com/