SQL Server Performance Forum – Threads Archive

Maintain connection after failover

I don’t think this is possible, but does anyone know of a way for end-users to maintain their SQL connections during a failover. When the other node takes over, is there a way to prevent the users from having to shut down their app and relogin?
thanks.

In flight transactions are lost and your session must be renewed. Reconnecting can be transparent though – what is your authentication like?

All users are essentially connected to the database as the same user. The app has it’s own authentication, then the users connect through the same user id.

Is that through an application role? Is ODBC used?

SQL Virtual Server client connections must be controlled by clients
http://support.microsoft.com/default.aspx?scid=kb;en-us;273673

]]>