SQL Server Performance

Database Applications

Discussion in 'SQL Server Clustering' started by quailj1973, May 21, 2004.

  1. quailj1973 New Member

    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
  2. bradmcgehee New Member

    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
    Webmaster
    SQL-Server-Performance.Com
  3. Argyle New Member

    Yes this is application dependent. You need to code your application to be cluster aware.

Share This Page