Database Applications | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Database Applications

We have a 2 node active/passive sql cluster. I am curently testing failover using a front end application, but when I change from node one to two. I get a connection error message on the front end application. Is this supposed to happen? I was under the impression that if one node failed the other would kick in without affecting the front end application. Jason Quail
This depends on the application, not the SQL Server cluster. Some programs are smart enough to automatically reconnect after a disconnection, while others are not, as it appears in your case. We have this same issue with our ERP software, so whenever the cluster fails over, all users must log out of their ERP client and log back in. —————————–
Brad M. McGehee, MVP
Yes this is application dependent. You need to code your application to be cluster aware.