September 9, 2008 at 12:34 am
dear all
How to Restrict access of Database for one particular Host/IP address in database level? There is some problem doing it through Router/Switch. I am using SQL Server 2000 and Server is within a domain. Pls respond if anybody can help........
Thanks,
Ani
September 10, 2008 at 8:09 am
There is no way I am aware of within SQL Server to restrict access to SQL Server based on IP or host name. I suppose in SQL Server 2005 you might be able to do it with a LOGON trigger, but that is not an option in SQL Server 2000. Normally to do this you use a router/firewall.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
September 10, 2008 at 10:23 pm
If it is possible through port number...........
Ani
October 1, 2008 at 9:19 am
Yes there is a way. You need something like a sql server firewall or proxy that will give you this kind of control. There is a version available for free on the pynlogic site. You can limit by IP, MAC, user id/group (database or Active Directory) and time. Works for SQL Server 2000 and 2005. These products work as inline solutions, so the applications need to connect to the proxy instead of the firewall directly.
Hope this helps.
Herve Roggero
hroggero@pynlogic.com
MCDBA, MCSE, MCSD
SQL Server Database Proxy/Firewall and Auditing
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply