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 (AT) discussions (DOT) microsoft.com> wrote

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: