Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Cluster Virtual Name and Instance names Expand / Collapse
Author
Message
Posted Wednesday, September 10, 2008 1:27 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, September 16, 2014 3:33 PM
Points: 1,143, Visits: 994
I'm setting up an active/active cluster. I have my defaut instance setup already. Assume the virtual name is MACHINE1

I wanted to setup some named instances using the same virtual name, but different instance names like this:

MACHINE1
MACHINE1\Instance1
MACHINE1\instance2
MACHINE1\instance3

2 questions here:
1. is the above scenario possible?
2. if the above scenario is not possible, since it seems to want unique virtual names, then can you have several default instances on one cluster since they would have unique virtual names?


Any guidance and insight here is much appreciated
Thanks
Post #567258
Posted Tuesday, July 5, 2011 3:10 PM


SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Thursday, November 14, 2013 11:03 AM
Points: 80, Visits: 204
You can have an active/active you just have to give them unique names. You can have one default, sort of, instance with no instance name.
so instead of:

MACHINE1
MACHINE1\instance1
MACHINE1\instance2

you'd have to do something like this to get it to work

MACHINE1
MACHINE2\instance1
MACHINE3\instance2
.........

MACHINE1,2,3 are really just virtual names in Active Directory that point to the SQL cluster IP Address.

Hope this helps.




thanks, ERH
Post #1136854
Posted Wednesday, July 6, 2011 6:09 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: 2 days ago @ 1:56 PM
Points: 6,365, Visits: 13,695
Adam Angelini (9/10/2008)

1. is the above scenario possible?

No!

Adam Angelini (9/10/2008)

2. if the above scenario is not possible, since it seems to want unique virtual names, then can you have several default instances on one cluster since they would have unique virtual names?

No!

The sql server instances are installed on the same physical machine and you may only have one default instance per machine. The virtual network names are a DNS reference point to the virtual IP address, this is transferred between nodes during failover.


-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs"
Post #1137165
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse