Msg 15151, Level 16, State 1, Line 1 Cannot alter the login 'Domain\Group', because it does not exist or you do not have permission.

12 May,2017 by Jack Vamvas

Msg 15151, Level 16, State 1, Line 1 Cannot alter the login 'Domain\Group', because it does not exist or you do not have permission appeared when attempting to DISABLE a login.   The statement I was executing was :

 

ALTER LOGIN [DOMAIN\a_group] DISABLE
GO

 

I checked my permissions with How to check my SQL permissions

Workaround\fix

According to the SQL Server BOL You cannot disable windows groups. This may force you to either lower the privileges or drop the login

If you want to drop the loging , check with application owner and also script out the login prior to DROP.

 

 


Author: Jack Vamvas (http://www.sqlserver-dba.com)


Share:

Verify your Comment

Previewing your Comment

This is only a preview. Your comment has not yet been posted.

Working...
Your comment could not be posted. Error type:
Your comment has been posted. Post another comment

The letters and numbers you entered did not match the image. Please try again.

As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.

Having trouble reading this image? View an alternate.

Working...

Post a comment on Msg 15151, Level 16, State 1, Line 1 Cannot alter the login 'Domain\Group', because it does not exist or you do not have permission.


sqlserver-dba.com | SQL Server Performance Tuning | SQL Server DBA:Everything | FAQ | Contact|Copyright & Disclaimer