Unable to start SQL Server Service on a cluster instance | SansSQL

Tuesday, October 8, 2013

Unable to start SQL Server Service on a cluster instance

When you try to bring online the SQL Server cluster service, it might fail with the error "Login timeout expired".

In my case the SQL Server version was SQL Server 2005 and when I failover to Node1 it was working fine, however when I failback to Node2, it was failing with this error.

This is unusually right?
It works on one node but not on the other node.

Along with this message, there were couple of other messages logged in the event viewer.

Cause:
When I investigated on this error, I found that the "SQL Server Browser" service was not started on the node on which the SQL Services were failing to come online.
On the other node the "SQL Server Browser" was started so the SQL Server service was coming online without any errors.

Resolution:
Start the "SQL Server Browser" service on the node where the SQL Services are failing.

No comments:

Post a Comment