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.

  • May 21, 2013 at 3:12 pm

    #1617200

    You don't. You've opened the floodgates.

    However, there's a hardware mechanism you can use if you've got a centralized N-Tier and these users aren't running the app off their PCs. Firewall your SQL Server and only allow particular IPs to access it, and then open up those IPs that the application/N-Tier resides on.

    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
    Twitter: @AnyWayDBA