MSSQLSERVER_33129

Details

Product Name

SQL Server

Product Version

11.0

Product Build Number

 

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