|
Posted by simonrl on March 11, 2008, 4:27 pm
Please log in for more thread options
Hope I've got the right group for this question - fist post.
This is a relatively new area for me having recently rented a Win2K3 box to
host some web sites on. I have installed SQL 2005 onto the server and would
like to limit access on 1433 / 1434 to specific IP addresses only.
The server came with a pre-configured 'IP Security Policy on Local Computer'
under the Local Security Settings snap-in. This has a range of pre-defined
rules that can be Deny/Permit/Request Security/Require Security.
There is a pre-defined MSDE/MS SQL rule that AFAICT can either be permit all
or deny all. If I set it to Permit I can connect using SQL Management Studio
remotely. If I set it to Deny I cannot.
The pre-defined rule contained eight filters, 4 each 1433 and 1434 and 4
each UDP and TCP. I have tried setting the Source Address and Destination
Address to the IP address of the server and the IP I want to allow SQL access
to; however all I can acheive is open access to SQL ports or no access at all.
Using this tool is it possible to disallow SQL access to all except specific
IP addresses? Or is that beyond it's capabilities.
Thanks,
Simon
| 
XML Sitemap