Post reply

Will multi-instances introduce unique SQL Virtual IP addresses?

  • November 12, 2008 at 1:31 pm

    #201333

    If I install 3 instances SQL Server 2005 on a cluster (2-node), will I have 3 unique SQL Virtual IP addresses / 1 per instance?

    SQL Virtual Name: SQL01/Inst_1

    SQL Virtual IP: 111.22.33.111

    SQL Virtual Name: SQL02/Inst_2

    SQL Virtual IP: 111.22.33.222

    SQL Virtual Name: SQL03/Inst_3

    SQL Virtual IP: 111.22.33.333

    (residing on 3 physically clusered machines each w/ thier own unique machine name and unique IP address as well)

    BT

  • November 12, 2008 at 3:05 pm

    #897800

    I don't think that is what you will see. It should look just like multiple instances on a single, non-clustered server. Basically you should see the three named instances, 1 IP address and 3 different port addressess.

    SQL01/Inst_1, 111.22.33.111 port 1111

    SQL01/Inst_2, 111.22.33.111 port 2222

    SQL01/Inst_3, 111.22.33.111 port 3333

  • November 12, 2008 at 4:01 pm

    #897828

    You could have 2 different IPs, one on each node (active / active), or you could have 1 with different ports (active/passive), but not 3.

    If you had 3 nodes, you could go active/active/active

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

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