Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I'm picking up huge amounts of attempts to access our SQL database through port 1433 (Windows Server 2008).

How do I configure a firewall rule that only allows access from the box IP only so that the only way to access the SQL is when logged in by RDC.

Thanks.

share|improve this question

migrated from stackoverflow.com Mar 18 '11 at 13:32

This question came from our site for professional and enthusiast programmers.

    
You may have more luck with networking questions on Serverfault, if in a professional capacity, or Superuser otherwise. Also details on the OS version/release would help :-) – Wesley Werner Mar 18 '11 at 11:42

That's not really how it works. Your going to want to create a firewall rule with an exception for port 1433. Then you are going to have to figure out what your Scope is. On the rule you'll see a tab named Scope where you will want to modify the Remote IP Address section. You will want to add your static IP address or range there to allow connection. I am unaware of any way to dynamically grab the logged in RDP IP and apply that to an SQL firewall rule.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.