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" <pithhelmet@.discussions.microsoft.com> wrote in message
news:1EC91A6E-E933-4891-96E3-B001DDC312EF@.microsoft.com...
> 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
>
|||Hi Geoff,
No, this did not help in any way.
The SQL Server is already installed.
I simply cannot get it to start.
thanks for the reply.
take care
tony
"Geoff N. Hiten" wrote:

> See if this applies:
> http://support.microsoft.com/kb/815431
> --
> Geoff N. Hiten
> Senior SQL Infrastructure Consultant
> Microsoft SQL Server MVP
>
> "pithhelmet" <pithhelmet@.discussions.microsoft.com> wrote in message
> news:1EC91A6E-E933-4891-96E3-B001DDC312EF@.microsoft.com...
>