Multiple instances on cluster

Giganews Newsgroups
Subject: Multiple instances on cluster
Posted by:  Stu (S…@discussions.microsoft.com)
Date: Tue, 11 Dec 2007

On a stand alone server, our naming convention for multiple instances is:

server        (default instance)
server\IN1  (first named instance)
server\IN2  (second named instance)
etc, etc

Now, on a cluster, I understand the SQL name is made up of
virtualservername\instancename

So say the default instance is installed on the cluster as virtual name =
"server". We would refer to this server as "server"

Say the first named instance is IN1. Am I right in thinking I cannot use the
same virtual server name as the default instance because this name is used in
the cluster group, therefore I cannot have "server\IN1", "server\IN2", etc on
a cluster?

I would have to use something like

server1\IN1
server2\IN2

etc?

Replies