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];