Home Forums SQL Server 2008 Security (SS2K8) AD group has dbowner access to DB. How can I stop users from accessing from outside the application. RE: AD group has dbowner access to DB. How can I stop users from accessing from outside the application.

  • August 16, 2013 at 3:47 am

    #1642049

    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.