SQL 2005 Server on Cluster locked

[JVANH]

We were in the middle of an upgrade to an application when we received an error to due with strong passwords. We went to the Server to remove the checkbox and found the server was locked. (we think) Stop, Start, and restart are grey, there is no green arrow on the icon but it is running. We have done a restore of our backup and the applicaton seems to be running but the server still seems to be in a locked state. I do not want to attemt the upgrade again until we can unlock the server. THe server is on a cluser so restarting the WIndows server only fails the database over to another machine. when we fail it back to the primary server it is still locked.

any succestions would do.

Thanks

 

[mrdenny]

When working with a clustered SQL Server you shouldn't be starting and stopping the service from the services control pannel. You should be starting and stopping it from the cluster administrator.

What do you mean the server is locked? Are you talking about the server's console or an application account?

The SQL Server should respond the same way on either node of the cluster as the data files are all the same no matter which nodes it's running on.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com