XPost: microsoft.public.sqlserver.server   
   From: esquel@sommarskog.se   
      
   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?   
      
      
      
      
   --   
   Erland Sommarskog, SQL Server MVP, esquel@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   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)