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

Need to Install Multi Instance SQL Server on a 2-node A/P Cluster Expand / Collapse
Author
Message
Posted Monday, November 19, 2012 7:43 AM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Tuesday, September 9, 2014 3:28 AM
Points: 612, Visits: 462
Hi All,

I am trying to install Multiple instances of SQL Server 2008 R2 on a Windows Cluster in a Active / Passive Mode.

I have installed the Default Instance of the SQL Server but now when I am trying to install the Named Instance it's giving the SQL N/W name already in use.

My Requirement is as below:-

Physical Servers:-
SRV01
SRV02

Need to install Multipls instances on a Single IP / Network name:-

sql2k8cluster
sql2k8cluster\Instance1
sql2k8cluster\Instance2
sql2k8cluster\Instance3

I don't wanna change the IP for every Instance.

First of all is it possible to achieve this and if Yes the how???



Kindest Regards,

Jeetendra

Post #1386407
Posted Tuesday, November 20, 2012 4:12 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 4:51 AM
Points: 6,350, Visits: 13,674
Jeetendra (11/19/2012)
Hi All,

I am trying to install Multiple instances of SQL Server 2008 R2 on a Windows Cluster in a Active / Passive Mode.

I have installed the Default Instance of the SQL Server but now when I am trying to install the Named Instance it's giving the SQL N/W name already in use.

My Requirement is as below:-

Physical Servers:-
SRV01
SRV02

Need to install Multipls instances on a Single IP / Network name:-

sql2k8cluster
sql2k8cluster\Instance1
sql2k8cluster\Instance2
sql2k8cluster\Instance3

I don't wanna change the IP for every Instance.

First of all is it possible to achieve this and if Yes the how???

Each instance needs a separate unique IP address and virtual network name, this is by design!

so,

sql2k8cluster                    10.10.10.10
sql2k8cluster1\Instance1 10.10.10.11
sql2k8cluster2\Instance2 10.10.10.12
sql2k8cluster3\Instance3 10.10.10.13



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

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

Add to briefcase

Permissions Expand / Collapse