Friday, March 30, 2012

Multiple instances on cluster

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?
"Stu" <Stu@.discussions.microsoft.com> wrote in message
news:B9D979DD-7F4F-4B65-A719-6425881C2121@.microsoft.com...
> 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
correct
Rgds,
Edwin.

No comments:

Post a Comment