February 1, 2012 at 7:04 am
One of my server when down hard last night and when I try to be bring it up it giving me an error of Server TCP provider failed to listen on [ 'any' <ipv4> 1433]. Tcp port is already in use.
The Server is window 2003 Enterprise R2 SP1 on VMware. There is one instance on the server and no default instance.
Here error log report
2012-02-01 08:56:33.46 Server Microsoft SQL Server 2005 - 9.00.3233.00 (Intel X86)
Mar 6 2008 22:09:47
Copyright (c) 1988-2005 Microsoft Corporation
Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 1)
2012-02-01 08:56:33.56 Server (c) 2005 Microsoft Corporation.
2012-02-01 08:56:33.56 Server All rights reserved.
2012-02-01 08:56:33.56 Server Server process ID is 540.
2012-02-01 08:56:33.56 Server Authentication mode is MIXED.
2012-02-01 08:56:33.59 Server Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG'.
2012-02-01 08:56:33.60 Server This instance of SQL Server last reported using a process ID of 1488 at 2/1/2012 8:51:45 AM (local) 2/1/2012 1:51:45 PM (UTC). This is an informational message only; no user action is required.
2012-02-01 08:56:33.60 Server Registry startup parameters:
2012-02-01 08:56:33.62 Server -d C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf
2012-02-01 08:56:33.62 Server -e C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG
2012-02-01 08:56:33.62 Server -l C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf
2012-02-01 08:56:33.70 Server SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
2012-02-01 08:56:33.70 Server Detected 4 CPUs. This is an informational message; no user action is required.
2012-02-01 08:56:34.53 Server Address Windowing Extensions is enabled. This is an informational message only; no user action is required.
2012-02-01 08:56:35.54 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.
2012-02-01 08:56:36.67 Server Attempting to initialize Microsoft Distributed Transaction Coordinator (MS DTC). This is an informational message only. No user action is required.
2012-02-01 08:56:38.06 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.
2012-02-01 08:56:38.15 Server Database mirroring has been enabled on this instance of SQL Server.
2012-02-01 08:56:38.29 spid4s Starting up database 'master'.
2012-02-01 08:56:39.07 spid4s SQL Trace ID 1 was started by login "sa".
2012-02-01 08:56:39.12 spid4s Starting up database 'mssqlsystemresource'.
2012-02-01 08:56:39.14 spid4s The resource database build version is 9.00.3233. This is an informational message only. No user action is required.
2012-02-01 08:56:39.31 spid9s Starting up database 'model'.
2012-02-01 08:56:39.32 spid4s Server name is 'SIRSMIRROR\MIGM'. This is an informational message only. No user action is required.
2012-02-01 08:56:39.64 spid9s Clearing tempdb database.
2012-02-01 08:56:39.98 Server A self-generated certificate was successfully loaded for encryption.
2012-02-01 08:56:40.06 Server Server is listening on [ 'any' <ipv4> 1433].
2012-02-01 08:56:40.06 Server Error: 26023, Severity: 16, State: 1.
2012-02-01 08:56:40.06 Server Server TCP provider failed to listen on [ 'any' <ipv4> 1433]. Tcp port is already in use.
2012-02-01 08:56:40.10 Server Error: 17182, Severity: 16, State: 1.
2012-02-01 08:56:40.10 Server TDSSNIClient initialization failed with error 0x2740, status code 0xa.
2012-02-01 08:56:40.10 Server Error: 17182, Severity: 16, State: 1.
2012-02-01 08:56:40.10 Server TDSSNIClient initialization failed with error 0x2740, status code 0x1.
2012-02-01 08:56:40.10 Server Error: 17826, Severity: 18, State: 3.
2012-02-01 08:56:40.10 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.
2012-02-01 08:56:40.10 Server Error: 17120, Severity: 16, State: 1.
2012-02-01 08:56:40.10 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.
February 1, 2012 at 3:12 pm
This sounds like one where you should be calling CSS.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
February 1, 2012 at 3:15 pm
What is CSS?
February 1, 2012 at 3:21 pm
SOrry, that's Microsoft Customer Support Services. You might get someone on here or another forum to answer your question, but who knows when.
I did do a quick search on the error and found this, http://blogs.msdn.com/b/sql_protocols/archive/2006/04/28/585835.aspx, which might help.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
February 1, 2012 at 3:30 pm
OK, I made a change in the IP ALL TCP Dynamic Port to 0 from 1433 to get the server up, but the application cant connect to the server. The SQL Server is set up as a instance computer/MP and the application design to look for a default instance and everything was working fine until the power problem.
February 1, 2012 at 3:40 pm
I once had faced the same network related problem and was able to solve it by changing the service which the SQL Server process connected with to Local Service or Local System. I'm not sure of the case though.
If you manage to find out the reason this happens, please share.
Best regards,
Andre Guerreiro Neto
Database Analyst
http://www.softplan.com.br
MCITPx1/MCTSx2/MCSE/MCSA
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply