Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
IP1, IP2...IPALL
131 views
Skip to first unread message
sql464
Nov 17, 2011, 9:17:19 PM11/17/11
to
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?
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?
Erland Sommarskog
Nov 18, 2011, 3:32:51 AM11/18/11
to
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, esq...@sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
sql464
Nov 18, 2011, 4:40:55 AM11/18/11
to
On 18/11/2011 1:32 PM, Erland Sommarskog wrote:
> sql464 (sql...@nowhere.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?
>
I think I found the cause. SQL Server 2000 was also running on the
> sql464 (sql...@nowhere.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.
Erland Sommarskog
Nov 18, 2011, 6:15:42 AM11/18/11
to
sql464 (sql...@nowhere.com) writes:
> 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.
>
If you need both instances, you can of course change the port, or select a
> 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.
0 new messages