Groups > comp.databases.ms-sqlserver > #810

Re: IP1, IP2...IPALL

From	sql464 <sql464@nowhere.com>
Newsgroups	comp.databases.ms-sqlserver, microsoft.public.sqlserver.server
Subject	Re: IP1, IP2...IPALL
Date	2011-11-18 14:40 +0500
Organization	Aioe.org NNTP Server
Message-ID	<ja596p$mu6$1@speranza.aioe.org> (permalink)
References	<ja4f70$gp5$1@speranza.aioe.org> <Xns9FA1611F8814CYazorman@127.0.0.1>

Cross-posted to 2 groups.

Show all headers | View raw

On 18/11/2011 1:32 PM, Erland Sommarskog wrote:
> sql464 (sql464@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 
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.

Back to comp.databases.ms-sqlserver | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

IP1, IP2...IPALL sql464 <sql464@nowhere.com> - 2011-11-18 07:17 +0500
  Re: IP1, IP2...IPALL Erland Sommarskog <esquel@sommarskog.se> - 2011-11-18 08:32 +0000
    Re: IP1, IP2...IPALL sql464 <sql464@nowhere.com> - 2011-11-18 14:40 +0500
      Re: IP1, IP2...IPALL Erland Sommarskog <esquel@sommarskog.se> - 2011-11-18 11:15 +0000

csiph-web