November 20, 2007 at 8:13 am
This sql 2000 on win2k+3. There are 7 instances of SQL server on one of our servers. Off late I am noticing that whenever the instance start(server re-boot), I see that the following 2 messages:
SQL server listening on 127.0.0.1: PortNumber
SQL server listening on IP.Address: PortNumber
Not sure if I should worry about this. Any reason why? Also there seems to be no problems with dbaccess etc.
November 21, 2007 at 4:17 am
127.0.0.1 is the reserved IP address of (localhost).
All servers have this.
No need to worry about this.
November 21, 2007 at 4:28 am
When installing more than a sql instance on the same machine, only one may be default and that listen on port 1433, all the others being named instances - other than you have assigned static ports to the other 6, it is likely you have the ports changed after a server reboot. You may have to pay attention to this log entry as the apps may depend on the port no sql is running on. The ip add message is informational only.
November 26, 2007 at 10:42 am
As stated above, this is informational. If you have multiple instances, you should set them assigned ports so they aren't constantly changing. Your network people should know which ports are being used so they can protect those ports and be sure they're properly secured.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply