Post reply

SQL Listening

  • July 15, 2004 at 4:11 pm

    #85918

    When SQL Server 2000 sp3 ( on Windows 2000 Server ) starts, the Server error log reports the following:

    SQL Server listening on nn.n.n.n:1433

    SQL Server listening on nnn.nn.nn.nnn:1433

    SQL Server listening on nn.nn.nn.nn:1433

    The last entry is the IP address of the actual server. What do the other "listenings" mean?

     

  • July 19, 2004 at 8:00 am

    This was removed by the editor as SPAM

  • July 25, 2004 at 6:40 pm

    #516012

    Listening on 127.0.0.1 means localhost, and that's not a cause for concern.

    Is the computer multi-homed? Does it have more than 1 IP address configured? You can check this by running ipconfig from the command line (or through xp_cmdshell).

    K. Brian Kelley
    @kbriankelley

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply