Cluster SQL will not start - SQL Server Forums

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.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

Cluster SQL will not start

Author

Topic

pithhelmet
Posting Yak Master

183 Posts

Posted - 2007-12-18 : 11:18:48

Hi everyone -

I have a cluster setup with two machines (they seem to be working OK)

But i try to start up the SQL 2000 and i am get this log...

2007-12-18 11:10:53.34 server Microsoft SQL Server 2000 - 8.00.2040 (Intel X86)
May 13 2005 18:33:17
Copyright (c) 1988-2003 Microsoft Corporation
Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 1)

2007-12-18 11:10:53.34 server Copyright (C) 1988-2002 Microsoft Corporation.
2007-12-18 11:10:53.34 server All rights reserved.
2007-12-18 11:10:53.34 server Server Process ID is 3196.
2007-12-18 11:10:53.34 server Logging SQL Server messages in file 'Z:\Program Files\Microsoft SQL Server\MSSQL\log\ERRORLOG'.
2007-12-18 11:10:53.34 server SQL Server is starting at priority class 'normal'(4 CPUs detected).
2007-12-18 11:10:53.36 server Cannot use Address Windowing Extensions because lock memory privilege was not granted.
2007-12-18 11:10:53.41 server Working Set size set to 1520448 kilobytes.
2007-12-18 11:10:53.41 server SQL Server configured for thread mode processing.
2007-12-18 11:10:53.42 server Using dynamic lock allocation. [2500] Lock Blocks, [5000] Lock Owner Blocks.
2007-12-18 11:10:53.49 server Attempting to initialize Distributed Transaction Coordinator.
2007-12-18 11:10:53.49 server Failed to obtain TransactionDispenserInterface: XACT_E_TMNOTAVAILABLE
2007-12-18 11:10:53.49 spid3 Starting up database 'master'.
2007-12-18 11:10:53.52 server Using 'SSNETLIB.DLL' version '8.0.2039'.
2007-12-18 11:10:53.52 spid5 Starting up database 'model'.
2007-12-18 11:10:53.52 spid3 Server name is 'SQLVIRTUALA'.
2007-12-18 11:10:53.52 spid9 Starting up database 'QFWinData_ProdFinal'.
2007-12-18 11:10:53.52 spid8 Starting up database 'msdb'.
2007-12-18 11:10:53.52 spid10 Starting up database 'QFWinData_Template'.
2007-12-18 11:10:53.52 spid11 Starting up database 'QFWinData_ProdTest'.
2007-12-18 11:10:53.52 spid12 Starting up database 'QFWinData_QQ999992'.
2007-12-18 11:10:53.52 spid13 Starting up database 'Common'.
2007-12-18 11:10:53.52 spid14 Starting up database 'DBAWork'.
2007-12-18 11:10:53.52 server Error: 17826, Severity: 18, State: 1
2007-12-18 11:10:53.52 server Could not set up Net-Library 'SSNETLIB'..
2007-12-18 11:10:53.52 server Unable to load any netlibs.
2007-12-18 11:10:53.52 server SQL Server could not spawn FRunCM thread.

I cannot seem to get the SQL server to start up....

I try to run the Server Network Utility, but it fails to start with a message

The SQL server SQLVIRTUALA is a cluster resource. We are not able to connect to the cluster server at the moment. No valid data could be retrieved and shown.

I guess this error is due to the fact i cannot start the SQL server...

if anyone has any ideas, please share them

thanks
tony

RickD
Slow But Sure Yak Herding Master

3608 Posts

Posted - 2007-12-18 : 11:25:23

There is a KB article on this:

http://support.microsoft.com/kb/883732

pithhelmet
Posting Yak Master

183 Posts

Posted - 2007-12-18 : 15:34:18

tried that -

it failed.

Any other ideas?

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-12-18 : 15:36:58

What does Event Viewer show for the error when you attempt to bring the cluster group online via Cluster Administrator?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

pithhelmet
Posting Yak Master

183 Posts

Posted - 2007-12-18 : 16:50:49

Hi everyone -

Tara, there are no errors when the Cluster Administrator starts, and there are no errors in the event viewer.

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-12-18 : 22:06:18

Is cluster service running on all nodes?

RickD
Slow But Sure Yak Herding Master

3608 Posts

Posted - 2007-12-19 : 04:03:35

quote:
Originally posted by pithhelmet

tried that -

it failed.

Any other ideas?

You haven't changed the IP Address at all? Or your network guys haven't accidently used it elsewhere?

The error in your log just points to these registry keys missing, so unless you have a problem elsewhere, then the keys must be missing.

pithhelmet
Posting Yak Master

183 Posts

Posted - 2007-12-19 : 09:10:07

AFAIK, the ip addresses haven't changed on the machine(s).

I can still RDP into them using the same IP.

The SQL Server port hasn't changed.

The registry keys are the same as the production cluster (except sql name change)

We did have a team member resign monday night, perhaps a login issue can keep the sql server from starting up??

I put my credentials into the server and tried to restart it, but no luck

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-12-19 : 15:12:17

What did you see in cluster admin?

pithhelmet
Posting Yak Master

183 Posts

Posted - 2007-12-20 : 08:58:12

What in particular would you like me to describe about the cluster admin panel??

RickD
Slow But Sure Yak Herding Master

3608 Posts

Posted - 2007-12-20 : 09:10:30

Do you see all the nodes for a start?

Can you navigate to all nodes?

On another note, have you checked that the username/pwd for your SQL Service accounts is correct and that the login in the services work?

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-12-20 : 15:56:42

Can you see all sql resources?

Can you failover sql to another node?

pithhelmet
Posting Yak Master

183 Posts

Posted - 2007-12-20 : 17:09:51

Yes, both nodes are available, and i can move the Cluster Group between the machines.

The quorum and data drives are alive and well.

The SQL Server resource is the only one that is failed.

pithhelmet
Posting Yak Master

183 Posts

Posted - 2007-12-20 : 17:12:58

user name and passwords are all ok, even created a new series with admin level privs and the services refuse to start....

On a side note, is there a way to remove SQL server virtual server completely, so i can re-install.

not that it will correct the issue, but might have to as a last resort.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-12-20 : 17:19:37

Sure, just uninstall from Add/Remove programs like you would any other normal SQL Server.

Why don't you just open a case with Microsoft on this though? It's relatively cheap to get support from them.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

pithhelmet
Posting Yak Master

183 Posts

Posted - 2007-12-21 : 08:41:32

Hi Tara,

The MS SQL is not shown in the add/remove programs....

and when i run the installer (to uninstall it) the option is not presented

This is a crazy mess

thanks for the reply

take care
tony

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-12-21 : 10:35:13

You don't see an item named "Microsoft SQL Server 2000" under add/remove programs? If not, then your system is jacked. You'll probably have to manually remove SQL Server using a KB article.

I'd highly suggest calling Microsoft now.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

pithhelmet
Posting Yak Master

183 Posts

Posted - 2007-12-21 : 16:47:26

on the line with them since 9:00 am

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources