Home Forums SQL Server 2008 Security (SS2K8) Best way to completely keep an entire Active Directory group of people out of a SQL Server RE: Best way to completely keep an entire Active Directory group of people out of a SQL Server

  • If they're in a Windows security group, you can add the group as a login and deny permission to connect to the SQL Server.

    However, this is usually seen as a method of last resort. Someone could always be added to the group that you didn't intend to block.

    K. Brian Kelley
    @kbriankelley