Cluster issue

I'm having an issue with a two node cluster. We're using failover clustering
in SQL 2000 but everytime the first node fails it doesn't automatically
failover to the second node. Are there any KB articles dealing with this?
I've searched but can't seem to find what I'm looking for. Thanks in advance.http://www.microsoft.com/technet/archive/winntas/support/mscstswp.mspx
--
MG
"Nicholas" wrote:
> I'm having an issue with a two node cluster. We're using failover clustering
> in SQL 2000 but everytime the first node fails it doesn't automatically
> failover to the second node. Are there any KB articles dealing with this?
> I've searched but can't seem to find what I'm looking for. Thanks in advance.|||You need to look at the SQL Server and System Event Application logs to see
what resource is not coming online and why. There are many reasons why a
cluster won't fail over, so finding the exact cause is the first step. If
you have troubleshooting time, you can manually (using the Cluster
Administrator tool) take the SQL group offline, move it to the other node,
and bring each resource online one at a time to see exactly where it fails.
Post your results and we will go from there.
Geoff N. Hiten
Microsoft SQL Server MVP
"Nicholas" <Nicholas@.discussions.microsoft.com> wrote in message
news:509577DA-5060-4B80-A61D-28981BED4233@.microsoft.com...
> I'm having an issue with a two node cluster. We're using failover
> clustering
> in SQL 2000 but everytime the first node fails it doesn't automatically
> failover to the second node. Are there any KB articles dealing with this?
> I've searched but can't seem to find what I'm looking for. Thanks in
> advance.|||Thanks. Didn't think to check TechNet for some reason.
"MGeles" wrote:
> http://www.microsoft.com/technet/archive/winntas/support/mscstswp.mspx
> --
> MG
>
> "Nicholas" wrote:
> > I'm having an issue with a two node cluster. We're using failover clustering
> > in SQL 2000 but everytime the first node fails it doesn't automatically
> > failover to the second node. Are there any KB articles dealing with this?
> > I've searched but can't seem to find what I'm looking for. Thanks in advance.