SQL Server & NLB (Fail Over)

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

fred.arnal@gmail.com - 27 Jul 2006 10:53 GMT

I would like to know if it's possible for the nlb to detect a close
connection from my server when SQL Server service is stopped ?

I can perfom the stuff with IIS (by updating metadatabase file), I
would like to know if something like this can be done with Sql Server
2000 (on Win 2003).

Best regards,

Fred

Reply to this Message

Russ Kaufmann [MVP] - 27 Jul 2006 16:26 GMT

>I would like to know if it's possible for the nlb to detect a close
> connection from my server when SQL Server service is stopped ?

No, it is not. NLB can detect if a node is failed, but does not check the
health of individual services.

Signature

Russ Kaufmann
MVP - Windows Server - Clustering
ClusterHelp.com, a Microsoft Certified Gold Partner
Web http://www.clusterhelp.com
Blog http://msmvps.com/clusterhelp

Reply to this Message

Fred - 31 Jul 2006 10:52 GMT

Ok, but I can the thing with IIS changing a metabase key (IIS close
connection when it detect a problem). The whole thing is just to have a close
connection on the port ?

Thanks for your answer
"Russ Kaufmann [MVP]" a écrit :

> >I would like to know if it's possible for the nlb to detect a close
> > connection from my server when SQL Server service is stopped ?
>
> No, it is not. NLB can detect if a node is failed, but does not check the
> health of individual services.

Reply to this Message

Russ Kaufmann [MVP] - 31 Jul 2006 19:01 GMT

> Ok, but I can the thing with IIS changing a metabase key (IIS close
> connection when it detect a problem). The whole thing is just to have a
> close
> connection on the port ?

Again, NLB can detect if a node is failed, but does not check the
health of individual services.

Signature

Russ Kaufmann
MVP - Windows Server - Clustering
ClusterHelp.com, a Microsoft Certified Gold Partner
Web http://www.clusterhelp.com
Blog http://msmvps.com/clusterhelp

Reply to this Message