Solved

Unable to start service after enabling TCP/IP

Posted on 2007-11-24
4
1,467 Views
Last Modified: 2010-05-18
I've recently installed an instance of SQL Sever 2005 Express. Now I've googled and found that it doesn't support external connections by default - you need to enable TCP/IP then restart the service.

Once I enable TCP/IP (SQL Server Config Manager -> Protocols for SQLExpress) then try restart the service (SQL Server 2005 Services) it stops, but wont start again (times out).

Any ideas on what is going on???

Dave
0
Comment
Question by:flavo
  • 2
  • 2
4 Comments
 
LVL 142

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 20342785
can you get the ERRORLOG file of the sql server instance, it should contain more information about what goes wrong.
0
 
LVL 34

Author Comment

by:flavo
ID: 20342886
Here's what that shows, I have no idea..

2007-11-25 01:28:23.10 Server      (c) 2005 Microsoft Corporation.
2007-11-25 01:28:23.10 Server      All rights reserved.
2007-11-25 01:28:23.10 Server      Server process ID is 5296.
2007-11-25 01:28:23.10 Server      Authentication mode is MIXED.
2007-11-25 01:28:23.10 Server      Logging SQL Server messages in file 'c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG'.
2007-11-25 01:28:23.10 Server      This instance of SQL Server last reported using a process ID of 572 at 11/25/2007 1:28:15 AM (local) 11/24/2007 3:28:15 PM (UTC). This is an informational message only; no user action is required.
2007-11-25 01:28:23.10 Server      Registry startup parameters:
2007-11-25 01:28:23.10 Server             -d c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf
2007-11-25 01:28:23.10 Server             -e c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG
2007-11-25 01:28:23.10 Server             -l c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf
2007-11-25 01:28:23.14 Server      SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
2007-11-25 01:28:23.14 Server      Detected 2 CPUs. This is an informational message; no user action is required.
2007-11-25 01:28:23.87 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.
2007-11-25 01:28:23.89 Server      The time stamp counter of CPU on scheduler id 1 is not synchronized with other CPUs.
2007-11-25 01:28:23.90 Server      Database mirroring has been enabled on this instance of SQL Server.
2007-11-25 01:28:23.90 spid5s      Starting up database 'master'.
2007-11-25 01:28:24.01 spid5s      Recovery is writing a checkpoint in database 'master' (1). This is an informational message only. No user action is required.
2007-11-25 01:28:24.17 spid5s      SQL Trace ID 1 was started by login "sa".
2007-11-25 01:28:24.20 spid5s      Starting up database 'mssqlsystemresource'.
2007-11-25 01:28:24.21 spid5s      The resource database build version is 9.00.3042. This is an informational message only. No user action is required.
2007-11-25 01:28:24.56 spid5s      Server name is 'DAVE\EXPRESS2005'. This is an informational message only. No user action is required.
2007-11-25 01:28:24.56 Server      Error: 17182, Severity: 16, State: 1.
2007-11-25 01:28:24.56 Server      TDSSNIClient initialization failed with error 0xd, status code 0x10.
2007-11-25 01:28:24.56 spid8s      Starting up database 'model'.
2007-11-25 01:28:24.56 Server      Error: 17182, Severity: 16, State: 1.
2007-11-25 01:28:24.56 Server      TDSSNIClient initialization failed with error 0xd, status code 0x1.
2007-11-25 01:28:24.56 spid5s      Starting up database 'msdb'.
2007-11-25 01:28:24.56 Server      Error: 17826, Severity: 18, State: 3.
2007-11-25 01:28:24.56 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.
2007-11-25 01:28:24.57 Server      Error: 17120, Severity: 16, State: 1.
2007-11-25 01:28:24.57 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.


Now as soon as I turn off TCP/IP


2007-11-25 01:30:11.01 Server      (c) 2005 Microsoft Corporation.
2007-11-25 01:30:11.01 Server      All rights reserved.
2007-11-25 01:30:11.01 Server      Server process ID is 5664.
2007-11-25 01:30:11.03 Server      Authentication mode is MIXED.
2007-11-25 01:30:11.03 Server      Logging SQL Server messages in file 'c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG'.
2007-11-25 01:30:11.03 Server      This instance of SQL Server last reported using a process ID of 5716 at 11/25/2007 1:29:26 AM (local) 11/24/2007 3:29:26 PM (UTC). This is an informational message only; no user action is required.
2007-11-25 01:30:11.03 Server      Registry startup parameters:
2007-11-25 01:30:11.03 Server             -d c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf
2007-11-25 01:30:11.03 Server             -e c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG
2007-11-25 01:30:11.03 Server             -l c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf
2007-11-25 01:30:11.03 Server      SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
2007-11-25 01:30:11.03 Server      Detected 2 CPUs. This is an informational message; no user action is required.
2007-11-25 01:30:11.78 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.
2007-11-25 01:30:11.79 Server      The time stamp counter of CPU on scheduler id 1 is not synchronized with other CPUs.
2007-11-25 01:30:11.79 Server      Database mirroring has been enabled on this instance of SQL Server.
2007-11-25 01:30:11.79 spid5s      Starting up database 'master'.
2007-11-25 01:30:12.06 spid5s      SQL Trace ID 1 was started by login "sa".
2007-11-25 01:30:12.09 spid5s      Starting up database 'mssqlsystemresource'.
2007-11-25 01:30:12.12 spid5s      The resource database build version is 9.00.3042. This is an informational message only. No user action is required.
2007-11-25 01:30:12.48 spid5s      Server name is 'DAVE\EXPRESS2005'. This is an informational message only. No user action is required.
2007-11-25 01:30:12.48 spid8s      Starting up database 'model'.
2007-11-25 01:30:12.48 spid5s      Starting up database 'msdb'.
2007-11-25 01:30:12.79 Server      A self-generated certificate was successfully loaded for encryption.
2007-11-25 01:30:12.79 Server      Server local connection provider is ready to accept connection on [ \\.\pipe\SQLLocal\EXPRESS2005 ].
2007-11-25 01:30:12.79 Server      Server local connection provider is ready to accept connection on [ \\.\pipe\MSSQL$EXPRESS2005\sql\query ].
2007-11-25 01:30:12.79 Server      Dedicated administrator connection support was not started because it is not available on this edition of SQL Server. This is an informational message only. No user action is required.
2007-11-25 01:30:12.82 Server      SQL Server is now ready for client connections. This is an informational message; no user action is required.
2007-11-25 01:30:13.06 spid8s      Clearing tempdb database.
2007-11-25 01:30:13.70 spid8s      Starting up database 'tempdb'.
2007-11-25 01:30:13.85 spid5s      Recovery is complete. This is an informational message only. No user action is required.
2007-11-25 01:30:13.85 spid11s     The Service Broker protocol transport is disabled or not configured.
2007-11-25 01:30:13.85 spid11s     The Database Mirroring protocol transport is disabled or not configured.
2007-11-25 01:30:13.87 spid11s     Service Broker manager has started.
0
 
LVL 142

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 250 total points
ID: 20342943
the message to check out from that log is:
TDSSNIClient initialization failed with error 0xd, status code 0x10.

see here:
http://blogs.msdn.com/sql_protocols/archive/2005/10/14/480848.aspx
0
 
LVL 34

Author Comment

by:flavo
ID: 20344185
It wasn't a space, but I changed the IpAll TCP Dynamic Ports value to 1066 and it finally seems to work.

thx
Dave
0

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

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

So every once in a while at work I am asked to export data from one table and insert it into another on a different server.  I hate doing this.  There's so many different tables and data types.  Some column data needs quoted and some doesn't.  What …
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.
Concerto provides fully managed cloud services and the expertise to provide an easy and reliable route to the cloud. Our best-in-class solutions help you address the toughest IT challenges, find new efficiencies and deliver the best application expe…

930 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now