Groups | Blog | Home
all groups > sql server clustering > february 2006 >

sql server clustering : Multiple Instances


Ajuss
2/23/2006 2:05:27 PM
Iam planning to install multiple instances in active/active cluster.Will
there be ant problem if I use the same name for virtual server and the
instance name ?Any disadvantages?

Thanks
Mike Hodgson
2/24/2006 12:00:00 AM
The virtual server name must be unique on the network and the instance
name must be unique on the cluster.

What you would normally get on a cluster with multiple SQL instances is
each instance having its own unique virtual server name and its own
unique instance name (only 1 instance on a cluster can be the default
instance but I'd recommend making them all named instances for
consistency and to avoid confusion). Like:

Instance 1: VSQL1\Inst1
Instance 2: VSQL2\Inst2

or

Instance 1: SQL20\Production
Instance 2: SQL21\Test

or something similar.

--
*mike hodgson*
http://sqlnerd.blogspot.com



[quoted text, click to view]
AddThis Social Bookmark Button