• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 413
  • Last Modified:

Cannot start SQL 2005 service.

Hello SQL experts,
I have a MS SQL 2005 Developer Edition. I cannot start the SQL service.
Here is the error log:

2006-05-05 13:08:59.00 Server      (c) 2005 Microsoft Corporation.
2006-05-05 13:08:59.00 Server      All rights reserved.
2006-05-05 13:08:59.00 Server      Server process ID is 3120.
2006-05-05 13:08:59.00 Server      Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG'.
2006-05-05 13:08:59.00 Server      This instance of SQL Server last reported using a process ID of 3128 at 5/5/2006 12:41:09 PM (local) 5/5/2006 4:41:09 PM (UTC). This is an informational message only; no user action is required.
2006-05-05 13:08:59.00 Server      Registry startup parameters:
2006-05-05 13:08:59.00 Server             -d C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf
2006-05-05 13:08:59.00 Server             -e C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG
2006-05-05 13:08:59.00 Server             -l C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf
2006-05-05 13:08:59.01 Server      SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
2006-05-05 13:08:59.01 Server      Detected 1 CPUs. This is an informational message; no user action is required.
2006-05-05 13:08:59.20 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.
2006-05-05 13:08:59.21 Server      Attempting to initialize Microsoft Distributed Transaction Coordinator (MS DTC). This is an informational message only. No user action is required.
2006-05-05 13:08:59.21 Server      The Microsoft Distributed Transaction Coordinator (MS DTC) service could not be contacted.  If you would like distributed transaction functionality, please start this service.
2006-05-05 13:08:59.21 Server      Database Mirroring Transport is disabled in the endpoint configuration.
2006-05-05 13:08:59.23 spid5s      Starting up database 'master'.
2006-05-05 13:08:59.32 spid5s      SQL Trace ID 1 was started by login "sa".
2006-05-05 13:08:59.37 spid5s      Starting up database 'mssqlsystemresource'.
2006-05-05 13:08:59.57 spid5s      Server name is 'AMD3700\WOJTEKSQL'. This is an informational message only. No user action is required.
2006-05-05 13:08:59.76 Server      A self-generated certificate was successfully loaded for encryption.
2006-05-05 13:08:59.76 Server      Error: 17182, Severity: 16, State: 1.
2006-05-05 13:08:59.76 Server      TDSSNIClient initialization failed with error 0x7e, status code 0x60.
2006-05-05 13:08:59.76 Server      Error: 17182, Severity: 16, State: 1.
2006-05-05 13:08:59.76 Server      TDSSNIClient initialization failed with error 0x7e, status code 0x1.
2006-05-05 13:08:59.76 Server      Error: 17826, Severity: 18, State: 3.
2006-05-05 13:08:59.76 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.
2006-05-05 13:08:59.76 Server      Error: 17120, Severity: 16, State: 1.
2006-05-05 13:08:59.76 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.

Help!! Any suggestiong greatly appreciated.
Wojciech.
0
wdunski
Asked:
wdunski
1 Solution
 
vadim63Commented:
Check what network protocols are enabled for SQL Server in the SQL Configuration Manager application.  If the VIA protocol is enabled disable it and then try starting the SQL Server service again.
0
 
wdunskiAuthor Commented:
Wow I'm an idiot : )

Thank You!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now