Cannot start SQL Service (2000on cluster)

Hello everyone,

I am running in a cluster setup (this is working ok).

I cannot get the mssqlserver service to start.

Here is the error log...



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



Since i cannot get any service pack to install, i am stuck at SP1 level.

I thought there was an issue with the SSL, but i have the certificates
loaded on both nodes of the cluster.

I thought it was a permissions issue, so i set both the MSSQLServer and
SQLAgent to a new domain admininstration level user. still won't start.

Please advise

take care
tony

See if this applies:

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

--
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP


"pithhelmet" wrote in message

> Hello everyone,
>
> I am running in a cluster setup (this is working ok).
>
> I cannot get the mssqlserver service to start.
>
> Here is the error log...
>
>
>
> 2007-12-19 10:41:38.50 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-19 10:41:38.50 server Copyright (C) 1988-2002 Microsoft
> Corporation.
> 2007-12-19 10:41:38.50 server All rights reserved.
> 2007-12-19 10:41:38.50 server Server Process ID is 3068.
> 2007-12-19 10:41:38.50 server Logging SQL Server messages in file
> 'Z:\Program Files\Microsoft SQL Server\MSSQL\log\ERRORLOG'.
> 2007-12-19 10:41:38.50 server SQL Server is starting at priority class
> 'normal'(4 CPUs detected).
> 2007-12-19 10:41:38.51 server Cannot use Address Windowing Extensions
> because lock memory privilege was not granted.
> 2007-12-19 10:41:38.56 server Working Set size set to 1520448
> kilobytes.
> 2007-12-19 10:41:38.57 server SQL Server configured for thread mode
> processing.
> 2007-12-19 10:41:38.59 server Using dynamic lock allocation. [2500]
> Lock
> Blocks, [5000] Lock Owner Blocks.
> 2007-12-19 10:41:38.65 server Attempting to initialize Distributed
> Transaction Coordinator.
> 2007-12-19 10:41:38.65 server Failed to obtain
> TransactionDispenserInterface: XACT_E_TMNOTAVAILABLE
> 2007-12-19 10:41:38.65 spid3 Starting up database 'master'.
> 2007-12-19 10:41:38.68 server Using 'SSNETLIB.DLL' version '8.0.2039'.
> 2007-12-19 10:41:38.68 spid5 Starting up database 'model'.
> 2007-12-19 10:41:38.68 spid3 Server name is 'SQLVIRTUALA'.
> 2007-12-19 10:41:38.68 spid8 Starting up database 'msdb'.
> 2007-12-19 10:41:38.68 spid9 Starting up database
> 'QFWinData_ProdFinal'.
> 2007-12-19 10:41:38.68 spid10 Starting up database
> 'QFWinData_Template'.
> 2007-12-19 10:41:38.68 spid11 Starting up database
> 'QFWinData_ProdTest'.
> 2007-12-19 10:41:38.68 spid12 Starting up database
> 'QFWinData_QQ999992'.
> 2007-12-19 10:41:38.68 spid13 Starting up database 'Common'.
> 2007-12-19 10:41:38.68 spid14 Starting up database 'DBAWork'.
> 2007-12-19 10:41:38.68 server Error: 17826, Severity: 18, State: 1
> 2007-12-19 10:41:38.68 server Could not set up Net-Library 'SSNETLIB'..
> 2007-12-19 10:41:38.68 server Unable to load any netlibs.
> 2007-12-19 10:41:38.68 server SQL Server could not spawn FRunCM thread.
>
>
>
> Since i cannot get any service pack to install, i am stuck at SP1 level.
>
> I thought there was an issue with the SSL, but i have the certificates
> loaded on both nodes of the cluster.
>
> I thought it was a permissions issue, so i set both the MSSQLServer and
> SQLAgent to a new domain admininstration level user. still won't start.
>
> Please advise
>
> take care
> tony
>