Friday, March 30, 2012

Multiple IP's. Only want 1 for SQL 1433

Hi,
I've got an SQL server 2000 (sp3).
This box has multiple IP addresses. These are for web pages
But i only want the SQL server (port 1433) to listen on one of these addressses.
It seems to listen on all the addresses which i don't want it to. for sercuirty reasons as well
as for it's resource sake.
I've poked around in the properties and connection settings and it doesn't seem to let you change IP's only ports etc.
Please let me know how i can work this out..
Thankyou
There is no way to prevent SQL Server from listening on all the ip
addresses that are bound to NIC cards on the machine. If you want to limit
the ones that clients can connect to then that will have to be impletmented
at the client level.
Rand
This posting is provided "as is" with no warranties and confers no rights.

No comments:

Post a Comment