Need to Install Multi Instance SQL Server on a 2-node A/P Cluster

  • 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

  • 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" 😉

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply