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 ««12

SQL Cluster - Multi Instance Expand / Collapse
Author
Message
Posted Tuesday, March 20, 2012 8:47 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 1:26 PM
Points: 5,961, Visits: 12,847
hindle.steve (3/20/2012)
I have a SQL 2008 R2 Cluster name of say SQLCluster1 on NodeA with an instance name of Instance1 ie. SQLCluster1\Instance1. I also want to install another instance called Instance2 on NodeA/SQLCluster1 ie. SQLCluster1\Instance2.

Is this possible?

Thanks

Steve

No, each clustered instance requires a virtual network name that is unique in the domain and should conform to standard Windows network name standards, including number of chars and excluded chars.


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

"Ya can't make an omelette without breaking just a few eggs"
Post #1269615
Posted Tuesday, February 26, 2013 1:13 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, March 19, 2014 4:52 AM
Points: 42, Visits: 86
Can a single computer be part of multiple clusters?
Post #1423916
Posted Tuesday, February 26, 2013 3:47 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 1:26 PM
Points: 5,961, Visits: 12,847
Kaushal.M (2/26/2013)
Can a single computer be part of multiple clusters?

No, a computer can be a member of only one cluster


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

"Ya can't make an omelette without breaking just a few eggs"
Post #1423978
Posted Wednesday, June 05, 2013 11:27 AM


Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Wednesday, April 16, 2014 1:45 PM
Points: 770, Visits: 1,178

I tried to do this (adding SQLName\Instance2 to existing SQLName\Instance1) today (SQL 2008 SP3 cluster) and confirmed it would NOT work @@
I was hoping it would work so I can consolidate multiple old SQL cluster instance names onto new clusters using DNS Alias to re-direct the SQLName part
e.g.
SQL1\I1
SQL2\I2
>> merge into >> SQLNew\I1, and SQLNew\I2 (so a 2-to-1, or N-to-1 merge)


guess the only way to have multiple named instances is a stand-alone server
SQLName\Instance1
SQLName\Instance2
SQLName\Instance3 ...


SQLServerNewbie

MCITP: Database Administrator SQL Server 2005
Post #1460346
Posted Wednesday, June 05, 2013 1:34 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Friday, January 03, 2014 3:52 PM
Points: 6,066, Visits: 5,277
SQL Clusters require a unique virtual name for each instance so you cannot do:

SQLName\Instance1
SQLName\Instance2
SQLName\Instance3

You must do:
SQLName1\Instance1
SQLName2\Instance2
SQLName3\Instance3

I believe this is because the virtual name/IP can only be active on a single node at a time and therefor if you have 3 instances each could be active on a different node.

CEWII
Post #1460412
Posted Wednesday, June 05, 2013 1:44 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 1:26 PM
Points: 5,961, Visits: 12,847
Also once you have installed an instance name as a clustered instance you cannot install a stand alone instance of the same name into any node in the cluster, whether the clustered instance is installed there or not!

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

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

Add to briefcase ««12

Permissions Expand / Collapse