Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-05-09 : 09:44:43
|
| Olesya writes "I've got a SQL2000 Cluster running on Windows 2000 AS. I recently applied the MS02-020 patch on the passive SQL server, which I will call A and I transferred all the services over to Server A- which is now active. Meanwhile, I can not start the MSSQLSERVER service on server B (the original Active server). When I try to start the service, I get a MMC warning that says the following:Could not start the MSSQL service on Local Computer. THe service did not return an error. This could be an internal Windows error or an internal service error. If the problem persists, contact your system administrator.Anyone seen this before?" |
|
|
Kevin Snow
Posting Yak Master
149 Posts |
Posted - 2002-05-09 : 11:41:53
|
| If I understand you correctly, it may be your expectations that are at fault. On our cluster, SQL Server is only running on the ACTIVE node of the cluster. The passive node shows that SQL Server is not running as a service, and is in MANUAL startup mode. It is the Cluster's responsibility to start up services on the passive node in the event of a failover situation.Attempting to start the service manually on the passive node may well result in the error you are seeing, since the database files are in use and locked by the active node.If you expect SQL Server to be running on both nodes, than you could easily interpret this as an error condition, instead of the normal Cluster operating mode. IF you have the leeway to test, try shutting down your A server, and see whether the service starts up automatically on your B server without errors.Let me know if this turns out to be the case. |
 |
|
|
|
|
|
|
|
SQL2000 Cluster on Win 2000 AS w/MS02-020 patch