Applies to: SQL Server
|Product Name||SQL Server|
|Message Text||Cannot use ALTER_LOGIN with the DISABLE argument to deny access to a Windows group.|
This message occurs when attempting to disable the login of a Windows Group.
The login of a Windows Group cannot be disabled. To temporarily remove access permission granted to a Windows Group, REVOKE the CONNECT permission of the login for the Windows Group. Windows users might still have access through their individual login or through another Windows Group. The following example revokes the connect permission to the Accounting Group of the WESTCOAST domain.
REVOKE CONNECT TO [WESTCOAST\Accounting];