 | |
IP1, IP2...IPALL
microsoft.public.sqlserver.server microsoft.public.sqlserver.server
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
IP1, IP2...IPALL -
11-17-2011
, 08:17 PM
#2
| |||
| |||
|
|
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 the these IP Addresses. Can any one help me to figure out what goes in here? |
because TCP/IP is enabled.
Have you looked in the LOG directory of the SQL Server installation? You
should see the files ERRORLOG and ERRORLOG.1 to .6. There is one for each
time you start SQL Server. However, if SQL Server dies before it creates
the file, there is no file. So that is the first thing to check. Do you get
an Errorlog file, and in such case, is there any error message in it? If
you don't get any Errorlog, is there something else? A dump file?
--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx
#3
| |||
| |||
|
|
sql464 (sql464 (AT) nowhere (DOT) com) writes: 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 the these IP Addresses. Can any one help me to figure out what goes in here? Interesting. I don't think I've ever heard of SQL Server not starting because TCP/IP is enabled. Have you looked in the LOG directory of the SQL Server installation? You should see the files ERRORLOG and ERRORLOG.1 to .6. There is one for each time you start SQL Server. However, if SQL Server dies before it creates the file, there is no file. So that is the first thing to check. Do you get an Errorlog file, and in such case, is there any error message in it? If you don't get any Errorlog, is there something else? A dump file? |
computer and both were trying to listen to the same port so I was
getting the below error in 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.
When I stopped SQL 2000 and changed port everything was fine.
#4
| |||
| |||
|
|
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 below error in 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. When I stopped SQL 2000 and changed port everything was fine. |
dynamic port.
--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.