Transparent client redirection

#1

I'm new to server clustering, and need to implement a SQL Server 2008
cluster.
In http://support.microsoft.com/?id=273673 I read that when SQL Server 2005
fails over, the client is disconnected and it should handle the
reconnection. Does this apply to SQL Server 2008? If so, is there any other
way to do a transparent client redirection without losing client connection?

Thanks!

#2

"Gaspar" <noreply (AT) nospamplease (DOT) com> wrote

Quote:

I'm new to server clustering, and need to implement a SQL Server 2008
cluster.
In http://support.microsoft.com/?id=273673 I read that when SQL Server
2005 fails over, the client is disconnected and it should handle the
reconnection. Does this apply to SQL Server 2008? If so, is there any
other way to do a transparent client redirection without losing client
connection?

Yes, it applies to SQL Server 2008 as well. In order to provide transparent
reconnection, it must be written into the client application being used.

--
Russ Kaufmann,
MVP, MCSE: Messaging and Security, MCT, MCITP, MCTS and other stuff

ClusterHelp.com, a Microsoft Certified Gold Partner
Web http://www.clusterhelp.com
Blog http://msmvps.com/clusterhelp

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Transparent client redirection

microsoft.public.sqlserver.clustering microsoft.public.sqlserver.clustering

Transparent client redirection - 10-09-2009 , 08:22 AM

Re: Transparent client redirection - 10-09-2009 , 12:24 PM