MSSQLSERVER_33129
Applies to: SQL Server
Details
Attribute | Value |
---|---|
Product Name | SQL Server |
Event ID | 33129 |
Event Source | MSSQLSERVER |
Component | SQLEngine |
Symbolic Name | SEC_CANNOT_DISABLE_WIN_GROUP |
Message Text | Cannot use ALTER_LOGIN with the DISABLE argument to deny access to a Windows group. |
Explanation
This message occurs when attempting to disable the login of a Windows Group.
User Action
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];