Sign in
 
HomeLibraryLearnDownloadsTroubleshootingCommunityForums
SQL Server Developer Center >
> 
> 
Application connect Virtual IP or Host IP to connect to DB in sqlserver 2008 R2 cluster?

Con risposta Application connect Virtual IP or Host IP to connect to DB in sqlserver 2008 R2 cluster?

  • Wednesday, January 23, 2013 8:58 PM
     
     
    Sign In to Vote
    0

    Does application connect to VIP of the DB or host IP to connect to DB in sqlserver 2008 R2 cluster?

    Thanks,

    Ron.

     

All Replies

  • Wednesday, January 23, 2013 9:40 PM
     
     Answered
    Sign In to Vote
    0

    you need the virtual IP of the cluster group. Example : host ip : 192.16.16.01 and cluster IP is 192.16.18.14 and your instance name is test01, you need 192.16.18.14\Test01 to connect to database engine. hope it helps!!

    IMHO,I think the point in clustering is to make the services independent of the hosts(nodes)..so, you will need Virtual IP of the cluster group. 


    Hope it Helps!!



     
  • Friday, January 25, 2013 7:48 AM
    Moderator
     
     Answered
    Sign In to Vote
    0

    Hello,

    SQL Server does not listen on the IP address of the local servers. Instead, SQL Server listens only on the virtual IP address created during installation of the SQL Server failover cluster instance. 
    When create a cluster, one of the steps is to create a virtual cluster name and IP address. This name and address is shared by both of the servers in the cluster. When connect to a cluster, users don't connect to a node's specify name or IP address, but connect to the virual name and IP address.

    For more information, please see:Installing a SQL Server 2008 Failover Cluster

    Regards,
    Fanny Liu 

    Fanny Liu
    TechNet Community Support