Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 Block MS SQL database access by ip address

Author  Topic 

markpringle
Starting Member

11 Posts

Posted - 2011-08-13 : 16:40:10
How do I block access to a database by URL or IP Address. I've noticed in my log files that there are attempts to access my database. I want to restrict access so that only the ip address or url i say can even hit or access the database.

"Kindness is not a weakness, the contrary on the other hand is."

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-08-13 : 16:45:04
Block it at the firewall level.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

markpringle
Starting Member

11 Posts

Posted - 2011-08-13 : 17:59:06
quote:
Originally posted by tkizer

Block it at the firewall level.

Tara Kizer



Thanks. I just decided to rename and disable the sa account.

"Kindness is not a weakness, the contrary on the other hand is."
Go to Top of Page
   

- Advertisement -