Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Managing Connections to Clustered Database Servers

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-04-22 : 12:36:47
Steve writes "I have a SQL 7.0 database on an NT 4 cluster. After failing over from the primary to the secondary, I can always issue new queries from Query Analyzer without having to restart my connection, but the front end for the application that uses the database sometimes has to be restarted.

Microsoft's Cluster homepage gives a very brief explanation that the client's connection depends on whether it is statless or state-ful, but I'd like to give the developers clear and concrete guidelines for dealing with failover. Are there examples of the right way to do it?"
   

- Advertisement -