dbTalk Databases Forums  

Multiple instances on cluster

microsoft.public.sqlserver.clustering microsoft.public.sqlserver.clustering


Discuss Multiple instances on cluster in the microsoft.public.sqlserver.clustering forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Stu
 
Posts: n/a

Default Multiple instances on cluster - 12-12-2007 , 12:16 AM






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?

Reply With Quote
  #2  
Old   
Edwin vMierlo [MVP]
 
Posts: n/a

Default Re: Multiple instances on cluster - 12-12-2007 , 05:53 AM







"Stu" <Stu (AT) discussions (DOT) microsoft.com> wrote

Quote:
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.




Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.