Welcome to dbForumz.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Multiple instances on cluster

 
   Database Forums (Home) -> Clustering RSS
Next:  begin and end transaction and transaction log  
Author Message
Stu10

External


Since: Oct 12, 2004
Posts: 7



(Msg. 1) Posted: Tue Dec 11, 2007 10:16 pm
Post subject: Multiple instances on cluster
Archived from groups: microsoft>public>sqlserver>clustering (more info?)

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?

 >> Stay informed about: Multiple instances on cluster 
Back to top
Login to vote
Edwin vMierlo [MVP]

External


Since: Apr 04, 2007
Posts: 18



(Msg. 2) Posted: Wed Dec 12, 2007 7:58 am
Post subject: Re: Multiple instances on cluster [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

"Stu" wrote in message

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

 >> Stay informed about: Multiple instances on cluster 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Installing SP4 on multiple instances in a cluster - Hello, I'm looking for solution of minimizing downtime(amount of reboots) when installing SP4 on 3-node cluster running 8 SQL2K instances.I anderstood from readme file that after each instance installation boot of all nodes in a cluster required. It....

Single node cluster with multiple instances but all as def.. - Hi, I am trying to install multiple SQL 2005 instances onto one machine, which has been configured as a single node cluster. Multiple virtual servers have been created, and I am trying to install one instance onto each virtual server set up for SQL....

Multiple Instances SQL2K and 2005 - Hi, we have a 2 node cluster running Server 2003 with a single instance of SQL 2005. We are looking to migrate as many apps as possible to SQL 2005, but will likely need to keep a SQL2000 instance. In addition, we want to isolate some of the SQL..

active/passive with multiple instances - Our production enviornment consists of 2 production servers in an active\passive set up. The production enviornment has 3 instances. Is it possible that a single instance can fail over to the standby node and leaving the other 2 behind? We think..

3 node cluster with two SQL instances. Mixed SQL service p.. - We have a 2 node active/passive cluster running SQL2K SP4. I want to add another node and make it Active/Active/Passive with the one active node running the default SQL instance and the other Active running a named instance with the passive node..
   Database Forums (Home) -> Clustering All times are: Pacific Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]