Unanswered Active Topics Forums Search

UserName:
Subject:	restrict machines connecting to sqlserv
Body:	[quote]Posted By n/a on 07/17/2002 12:23 PM Here's a few places to start: 1. Place a firewall between the SQL Server and the rest of the network and only allow specific IP addresses. A device that allows specific rules or a personal firewall that does the same should do the trick (although I don't like software firewalls on critical servers.) 2. Use IPSec to restrict connectivity to other hosts. There are numerus tunnelling options you could try here as well. 3. Force protocol encryption on the server using a certificate only trusted by certain clients. By far I like the firewall option best. Its simplist and doesn't require any specific Windows OS tinkering (like enabling IPSec or installing certificates). Your typical firewall appliance for $50 should do the job nicely - especially since many of them come with a built-in switch as well. [/quote]
Show Replies:

ActiveForums 3.6