• Additional info

    from the sql server log

    2008-12-16 09:33:47.32 Server Microsoft SQL Server 2005 - 9.00.3159.00 (X64)

    Mar 23 2007 20:11:35

    Copyright (c) 1988-2005 Microsoft Corporation

    Enterprise Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 2)

    2008-12-16 09:33:47.33 Server (c) 2005 Microsoft Corporation.

    2008-12-16 09:33:47.33 Server All rights reserved.

    2008-12-16 09:33:47.33 Server Server process ID is 4708.

    2008-12-16 09:33:47.33 Server Authentication mode is MIXED.

    2008-12-16 09:33:47.33 Server Logging SQL Server messages in file 'S:\Microsoft SQL Server\MSSQL.4\MSSQL\LOG\ERRORLOG'.

    2008-12-16 09:33:47.33 Server This instance of SQL Server last reported using a process ID of 7420 at 15/12/2008 12:36:23 (local) 15/12/2008 12:36:23 (UTC). This is an informational message only; no user action is required.

    2008-12-16 09:33:47.33 Server Registry startup parameters:

    2008-12-16 09:33:47.35 Server -d S:\Microsoft SQL Server\MSSQL.4\MSSQL\DATA\master.mdf

    2008-12-16 09:33:47.35 Server -e S:\Microsoft SQL Server\MSSQL.4\MSSQL\LOG\ERRORLOG

    2008-12-16 09:33:47.35 Server -l S:\Microsoft SQL Server\MSSQL.4\MSSQL\DATA\mastlog.ldf

    2008-12-16 09:33:47.44 Server SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.

    2008-12-16 09:33:47.44 Server Detected 8 CPUs. This is an informational message; no user action is required.

    2008-12-16 09:33:47.50 Server Large Page Extensions enabled.

    2008-12-16 09:33:47.50 Server Large Page Granularity: 2097152

    2008-12-16 09:34:06.07 Server Large Page Allocated: 32MB

    2008-12-16 09:34:08.62 Server Using locked pages for buffer pool.

    2008-12-16 09:34:10.90 Server Using dynamic lock allocation. Initial allocation of 2500 Lock blocks and 5000 Lock Owner blocks per node. This is an informational message only. No user action is required.

    2008-12-16 09:34:11.85 Server Attempting to initialize Microsoft Distributed Transaction Coordinator (MS DTC). This is an informational message only. No user action is required.

    2008-12-16 09:34:22.29 Server Attempting to recover in-doubt distributed transactions involving Microsoft Distributed Transaction Coordinator (MS DTC). This is an informational message only. No user action is required.

    2008-12-16 09:34:22.33 Server Database mirroring has been enabled on this instance of SQL Server.

    2008-12-16 09:34:22.54 spid5s Starting up database 'master'.

    2008-12-16 09:34:23.62 spid5s SQL Trace ID 1 was started by login "sa".

    2008-12-16 09:34:23.69 spid5s Starting up database 'mssqlsystemresource'.

    2008-12-16 09:34:23.71 spid5s The resource database build version is 9.00.3159. This is an informational message only. No user action is required.

    2008-12-16 09:34:24.16 spid5s Server name is 'HMLUSQLAVS03\SYSTEM'. This is an informational message only. No user action is required.

    2008-12-16 09:34:24.16 spid9s Starting up database 'model'.

    2008-12-16 09:34:24.16 spid5s The NETBIOS name of the local node that is running the server is 'HMLBB9'. This is an informational message only. No user action is required.

    2008-12-16 09:34:24.66 Server A self-generated certificate was successfully loaded for encryption.

    2008-12-16 09:34:24.71 Server Error: 26054, Severity: 16, State: 1.

    2008-12-16 09:34:24.71 Server Could not find any IP address that this SQL Server instance depends upon. Make sure that the cluster service is running, that the dependency relationship between SQL Server and Network Name resources is correct, and that the IP addresses on which this SQL Server instance depends are available. Error code: 0x103.

    2008-12-16 09:34:24.71 Server Error: 17182, Severity: 16, State: 1.

    2008-12-16 09:34:24.71 Server TDSSNIClient initialization failed with error 0x103, status code 0xa.

    2008-12-16 09:34:24.71 Server Error: 17182, Severity: 16, State: 1.

    2008-12-16 09:34:24.71 Server TDSSNIClient initialization failed with error 0x103, status code 0x1.

    2008-12-16 09:34:24.71 Server Error: 17826, Severity: 18, State: 3.

    2008-12-16 09:34:24.71 Server Could not start the network library because of an internal error in the network library. To determine the cause, review the errors immediately preceding this one in the error log.

    2008-12-16 09:34:24.71 Server Error: 17120, Severity: 16, State: 1.

    2008-12-16 09:34:24.71 Server SQL Server could not spawn FRunCM thread. Check the SQL Server error log and the Windows event logs for information about possible related problems.

    Thanks