[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Cannot start SQL 2005 service.

Posted on 2006-05-05
2
Medium Priority
?
400 Views
Last Modified: 2008-01-09
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
Comment
Question by:wdunski
2 Comments
 
LVL 10

Accepted Solution

by:
vadim63 earned 1000 total points
ID: 16616839
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
 
LVL 2

Author Comment

by:wdunski
ID: 16616999
Wow I'm an idiot : )

Thank You!
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

An alternative to the "For XML" way of pivoting and concatenating result sets into strings, and an easy introduction to "common table expressions" (CTEs). Being someone who is always looking for alternatives to "work your data", I came across this …
When trying to connect from SSMS v17.x to a SQL Server Integration Services 2016 instance or previous version, you get the error “Connecting to the Integration Services service on the computer failed with the following error: 'The specified service …
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.
Suggested Courses

872 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question