Maybe I'm blind too 'cause I never figured out how to do this from within MS-SQL. One way would be by configuring a filter on a network firewall. Another would be by using Win2K's built-in ability to filter TCP/IP traffic on the box. A third would be to install a firewall directly on the box and configure the filter there. I've used the second option a couple of times with good success. For info on this, see the general Windows Help file and search on "TCP/IP Filtering" or "IPSEC". Both should give you ample info on how to restrict traffic by port (1433 for MS-SQL) and by IP address. Hope that helps. ----- Original Message ----- From: "Anthony Baratta" <Anthony at Baratta.com> : OK this should be simple, but I can't find the answer. : : With mySQL I can limit the remote connections to the DB by IP Address or : Domain Name. I can't seem to find the same functionality with MS SQL. : : I found the Server-To-Server On/Off switch. But I'm looking for a way to : limit the Enterprise Manager and Query Analyzer connections to the server : to just a target range for IP addresses. : : Am I just blind?