Wednesday, January 23, 2013 8:58 PM
Does application connect to VIP of the DB or host IP to connect to DB in sqlserver 2008 R2 cluster?
Wednesday, January 23, 2013 9:40 PM
you need the virtual IP of the cluster group. Example : host ip : 192.16.16.01 and cluster IP is 184.108.40.206 and your instance name is test01, you need 220.127.116.11\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 AMModerator
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
TechNet Community Support
- Marked As Answer by Fanny LiuMicrosoft Contingent Staff, Moderator Tuesday, January 29, 2013 10:10 AM