Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

AD group has dbowner access to DB. How can I stop users from accessing from outside the application. Expand / Collapse
Author
Message
Posted Friday, August 16, 2013 3:47 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Monday, July 21, 2014 5:35 AM
Points: 69, Visits: 565
As others have mentioned, I've run into this situation before and with the application running from a web server in our case. For security our SQL Servers run in their own VLAN with all traffic being managed by the firewall so it's really easy to restrict access by source IP or MAC address so that only approved servers can communicate with the SQL servers. We even went so far as to put in specific rules so a live web server couldn't connect to a PreProd SQL Server, and vice versa.
Post #1485063
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse