August 12, 2009 at 11:57 pm
Tried starting MSSQLSERVER from control panel. Error message " The SQL Server (MSSQLSERVER) service on Local computer started and then stopped. Some services stop automatically if they have work to do, for example the performance logs and alerts
Checked if TCP is running for SQL Server by netstat -abno
Only SQL Browser is running.
UDP 0.0.0.0:1434 *:* 2364
[sqlbrowser.exe]
Started SQL Server Configuraiton Manager
Checked SQL Native Client Configuration, client protocols. Only TCP/IP is enabled with default port 1433
Checked SQL Server 2005 Network Configuration, Protocols for MSSQLSERVER. TCP/IP is enabled.
Under IP Address tab here are the settings:
IP1
Active: Yes
Enabled: Yes
IP Address: 192.1681.1.64
TCP Dynamic Ports:
TCP Port: 1433
IP2
Active: Yes
Enabled: Yes
IP Address: 127.0.0.1
TCP Dynamic Ports:
TCP Port: 1433
IP All
TCP Dynamic Ports:
TCP Port: 1433
Checked registry entry: MSSQLSERVER, currentversion, supersocketnetlib, TCP
Default (value not set)
TCPPort is 1433
Checked SQL Server 2005 Services
SQL Server Browser : running
SQL Server (MSSQLServer): Stopped. Tried starting SQL Server (MSSQLServer)
Gives Error message: The Request failed or the service did not respond in a timely fashion. Consult the event log or other applicable error logs for details.
Here is the error log:
2009-08-13 00:17:59.24 Server (c) 2005 Microsoft Corporation.
2009-08-13 00:17:59.24 Server All rights reserved.
2009-08-13 00:17:59.24 Server Server process ID is 248.
2009-08-13 00:17:59.24 Server Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG'.
2009-08-13 00:17:59.24 Server This instance of SQL Server last reported using a process ID of 3116 at 8/13/2009 12:05:42 AM (local) 8/13/2009 5:05:42 AM (UTC). This is an informational message only; no user action is required.
2009-08-13 00:17:59.24 Server Registry startup parameters:
2009-08-13 00:17:59.24 Server -d C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf
2009-08-13 00:17:59.24 Server -e C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG
2009-08-13 00:17:59.24 Server -l C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf
2009-08-13 00:17:59.26 Server SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
2009-08-13 00:17:59.26 Server Detected 1 CPUs. This is an informational message; no user action is required.
2009-08-13 00:17:59.99 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.
2009-08-13 00:18:00.04 Server Attempting to initialize Microsoft Distributed Transaction Coordinator (MS DTC). This is an informational message only. No user action is required.
2009-08-13 00:18:01.09 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.
2009-08-13 00:18:01.10 Server Database Mirroring Transport is disabled in the endpoint configuration.
2009-08-13 00:18:01.12 spid5s Starting up database 'master'.
2009-08-13 00:18:01.26 spid5s SQL Trace ID 1 was started by login "sa".
2009-08-13 00:18:01.29 spid5s Starting up database 'mssqlsystemresource'.
2009-08-13 00:18:01.59 spid5s Server name is 'HP11889472630'. This is an informational message only. No user action is required.
2009-08-13 00:18:01.64 spid9s Starting up database 'model'.
2009-08-13 00:18:01.95 Server A self-generated certificate was successfully loaded for encryption.
2009-08-13 00:18:01.96 Server Error: 26023, Severity: 16, State: 1.
2009-08-13 00:18:01.96 Server Server TCP provider failed to listen on [ 'any'
2009-08-13 00:18:01.96 Server Error: 17182, Severity: 16, State: 1.
2009-08-13 00:18:01.96 Server TDSSNIClient initialization failed with error 0x271d, status code 0xa.
2009-08-13 00:18:01.96 Server Error: 17182, Severity: 16, State: 1.
2009-08-13 00:18:01.96 Server TDSSNIClient initialization failed with error 0x271d, status code 0x1.
2009-08-13 00:18:01.96 Server Error: 17826, Severity: 18, State: 3.
2009-08-13 00:18:01.96 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.
2009-08-13 00:18:01.96 Server Error: 17120, Severity: 16, State: 1.
2009-08-13 00:18:01.96 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.
As you can see the error "Server TCP provider failed to listen on [ 'any'
netstat does not list any TCP/IP runing on port 1433
I had installed JDBC driver from Microsoft.
Set classpath: .;C:\Program Files\Microsoft SQL Server 2005 JDBC Driver\sqljdbc_1.0\enu\sqljdbc.jar
Deleted Classpath and removed the directory Microsoft SQL Server 2005 JDBC Driver
Changed all the ports to 1435 and tried restarting, same error occurs.
Log file now says:
2009-08-13 00:47:46.48 Server Server TCP provider failed to listen on [ 'any'
Changed registry entry to 1435 and tried restarting, same error occurs.
I have tried everything I could think of.
Please Help!!
August 13, 2009 at 8:58 am
seems like something has to be listening on that port.
What do you get when you run netstat -anob? This should list all listening or connected ports by numerical name. In other words instead of microsoft-ds it will say 135. Also it will list the owning PID and executable so that you can more easily narrow down what is already started on that port.
-Luke.
August 13, 2009 at 9:33 am
Also, have a look at the following link. Going through those posts may have give you some more things to check...
http://www.sqlservercentral.com/Forums/Topic334467-149-2.aspx
Cheers,
-Luke.
Edit: corrected the link.
August 13, 2009 at 10:27 am
Under IP Address tab here are the settings:
IP1
Active: Yes
Enabled: Yes
IP Address: 192.1681.1.64TCP Dynamic Ports:
TCP Port: 1433
IP2
Active: Yes
Enabled: Yes
IP Address: 127.0.0.1
TCP Dynamic Ports:
TCP Port: 1433
IP All
TCP Dynamic Ports:
TCP Port: 1433
My TCP/IP properties say No whre yours say Yes. Not sure what that means.
But the second octet of your IP address - is it really 1681?
Greg E
August 13, 2009 at 10:31 am
Is this a typo on your part, or did you cut & paste?
Under IP Address tab here are the settings:
IP1
Active: Yes
Enabled: Yes
IP Address: 192.1681.1.64
TCP Dynamic Ports:
TCP Port: 1433
I am fairly certain that 1681 is not valid - but I am thinking it is just a typo when posting.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
August 13, 2009 at 10:46 am
Sorry, the IP address is a typo.
I did check netstat -oabn I did not find anything running for sqlserver. However sqlbrowser was listed.
August 13, 2009 at 12:45 pm
In my startup log, the mssqlsystemresource file is started.
The next line lists the build version - I'm on 9.00.3310.
I don't see a listing in yours.
Does this file exist? And do you know if it is the right one for your instance?
Maybe if you share a bit more of what led up to it not starting, it might help.
Greg E
August 13, 2009 at 10:27 pm
Tha log file has the build version as below:
2009-08-13 22:19:10.96 Server Microsoft SQL Server 2005 - 9.00.1406.00 (Intel X86)
Mar 3 2007 18:40:02
Copyright (c) 1988-2005 Microsoft Corporation
Developer Edition on Windows NT 5.1 (Build 2600: Service Pack 2)
Also I went to MSSQLSERVER startup paramters and verified that the files are located in the directories as specified.
-dC:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf;-eC:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG;-lC:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf
Also Under IP Address tab, I changed the settings of 'Enabled' parameter shown in bold :
IP1
Active: Yes
Enabled: No
IP Address: 192.168.1.64
TCP Dynamic Ports:
TCP Port: 1433
IP2
Active: Yes
Enabled: NO
IP Address: 127.0.0.1
TCP Dynamic Ports:
TCP Port: 1433
IP All
TCP Dynamic Ports:
TCP Port: 1433
Then I restarted same error comes up.
I don't know what else to do!
August 13, 2009 at 11:31 pm
Thank to the excellent article by Ramu Konidena
It helped me.
I had trouble stating SQLSERVER 2005 for two days. I did ipconfig/all it listed my IP xxx.xx.x.xx. I went to configuration manager and under TCP/IP protocol I set Listen All to 'NO'. The under IP Tab I set the following:
IP1
Active: Yes
Enabled: Yes
IP Address: xxx.xx.x.xx
TCP Dynamic Ports:
TCP Port: 1433
IP2
Active: Yes
Enabled: NO
IP Address: 127.0.0.1
TCP Dynamic Ports:
TCP Port: 1433
IP All
TCP Dynamic Ports:
TCP Port: 1433
I set the IP xxx.xx.x.xx enabled to Yes, based on the IP I see from ipconfig/all, as suggested by you.
Server did not start and errored out as IP in use
The I reversed it by disabling xxx.xx.x.xx and enabling 127.0.0.1 as follows:
IP1
Active: Yes
Enabled: No
IP Address: xxx.xx.x.xx
TCP Dynamic Ports:
TCP Port: 1433
IP2
Active: Yes
Enabled: Yes
IP Address: 127.0.0.1
TCP Dynamic Ports:
TCP Port: 1433
IP All
TCP Dynamic Ports:
TCP Port: 1433
Now it works.
Here are my questions:
1) How is this possible - since 127.0.0.1 is not even listed in ipconfig/all. Enabling this has no sense but it works and I can start the Server
2) Also when I run netstat -oanb I get two instances of sqlserver running as below with same process id:
TCP 127.0.0.1:1433 0.0.0.0:0 LISTENING 952
[sqlservr.exe]
TCP 127.0.0.1:1434 0.0.0.0:0 LISTENING 952
[sqlservr.exe]
Is this not a problem since I have not mentioned port 1434 anywhere? How two listners can work with same process id on different ports?
I am happy the server is running. But still I want to get over this confusion.
Please let me know.
August 14, 2009 at 11:11 am
SQL Browser service uses port 1434
Greg E
Viewing 10 posts - 1 through 10 (of 10 total)
You must be logged in to reply to this topic. Login to reply