IP1, IP2...IPALL

sql464 () 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?




Erland Sommarskog, SQL Server MVP,

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...books.mspx