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 address
ses.
It seems to listen on all the addresses which i don't want it to. for sercui
rty reasons as well
as for it's resource sake.
I've poked around in the properties and connection settings and it doesn't s
eem to let you change IP's only ports etc.
Please let me know how i can work this out..
ThankyouThere 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.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment