November 17, 2011 at 8:09 pm
What are these IP addresses in the properties of TCP/IP in configuration Manager of SQL Server 2005 Standard? How do I know what to type here? The problem is that if I enable TCP/IP and stop/start SQL Server service it doesn't start. It starts only if TCP/IP is disabled. And the only reason I can think of is that there are strange hex numbers in these IP Addresses. Can any one help me to figure out what goes in here?
November 17, 2011 at 8:34 pm
You use that window to specify which ip addresses on your machine you want sql server to listen for connections on.
The addresses with hex numbers are ip6 addresses.
http://msdn.microsoft.com/en-us/library/ms177440(v=SQL.90).aspx
what error message do you get when trying to start sql server?
November 17, 2011 at 8:34 pm
Oh, you shouldn't need to change any of the addresses in that window.
November 17, 2011 at 8:51 pm
When I enable TCP/IP and start SQL Server, it progresses for about half a minute and then says The request failed or the service couldn't start in a timely manner.
November 17, 2011 at 9:50 pm
what's the message in the sql server error log?
November 18, 2011 at 12:30 am
SpringTownDBA (11/17/2011)
what's the message in the sql server error log?
2011-11-18 15:27:32.80 Server Error: 26023, Severity: 16, State: 1.
2011-11-18 15:27:32.80 Server Server TCP provider failed to listen on [ 'any' <ipv4> 1433]. Tcp port is already in use.
2011-11-18 15:27:32.81 Server Error: 17182, Severity: 16, State: 1.
2011-11-18 15:27:32.81 Server TDSSNIClient initialization failed with error 0x2740, status code 0xa.
2011-11-18 15:27:32.81 Server Error: 17182, Severity: 16, State: 1.
2011-11-18 15:27:32.81 Server TDSSNIClient initialization failed with error 0x2740, status code 0x1.
2011-11-18 15:27:32.81 Server Error: 17826, Severity: 18, State: 3.
2011-11-18 15:27:32.81 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.
2011-11-18 15:27:32.81 Server Error: 17120, Severity: 16, State: 1.
2011-11-18 15:27:32.81 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.
November 18, 2011 at 2:42 am
sql464 (11/18/2011)
SpringTownDBA (11/17/2011)
what's the message in the sql server error log?2011-11-18 15:27:32.80 Server Error: 26023, Severity: 16, State: 1.
2011-11-18 15:27:32.80 Server Server TCP provider failed to listen on [ 'any' <ipv4> 1433]. Tcp port is already in use.
2011-11-18 15:27:32.81 Server Error: 17182, Severity: 16, State: 1.
2011-11-18 15:27:32.81 Server TDSSNIClient initialization failed with error 0x2740, status code 0xa.
2011-11-18 15:27:32.81 Server Error: 17182, Severity: 16, State: 1.
2011-11-18 15:27:32.81 Server TDSSNIClient initialization failed with error 0x2740, status code 0x1.
2011-11-18 15:27:32.81 Server Error: 17826, Severity: 18, State: 3.
2011-11-18 15:27:32.81 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.
2011-11-18 15:27:32.81 Server Error: 17120, Severity: 16, State: 1.
2011-11-18 15:27:32.81 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.
I think I found the cause. SQL Server 2000 was also running on the computer and both were trying to listen to the same port so I was getting the error.
When I stopped SQL 2000 and changed port everything was fine.
Viewing 7 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply