ODBC Connection during the Cluster Fail Over

[seaport]

One of my cluster SQL 2008 R2 cluster server failed over. Many Access databases that were connected to the server through ODBC (by the server name, not the IP address) worked fine after the fail-over.

However, another application (ProCenter) lost its connection to SQL Server after the fail-over, until the cluster server was rebooted and rolled back. The ProCenter was connected to the SQL server through ODBC connection (using the server name, not the IP Address). I could not figure out why the Access application worked but ProCenter failed.

Any suggestions?

Thanks.

 

[yelworcm]

Test to make sure that machine that the ProCenter application is on can correctly resolve the IP address of the virtual server. If it has a host file pointed to the physical node, you would expect this sort of behavior. A lot of applications written in Java also do not react well to a cluster failover (or any restart of SQL Server), as many of them do not have re-connection logic in their connection pools. That, however, would only require a restart of the java application, so the app could re-connect.

 

[seaport]

Thanks for the reply, which I totally agree. I told the ProCentor admin to restart the application first thing if the sql server fails over again.