November 18, 2026 at 4:02 pm
Has anyone ever seen this before?
I have sysadmin permission on a server. I tried to run code to revoke connect to a login (REVOKE CONNECT TO [MyDomain\WindowsSecurityGroup];), which failed with this error:
Msg 15151, Level 16, State 1, Line 5
Cannot find the user 'MyDomain\WindowsSecurityGroup', because it does not exist or you do not have permission.
The name was correctly spelled. I even pulled it from Object Explorer to the query window, removed the square brackets and tried again. Still got the same error. Punctuation and capitalization was all correct.
I manually opened up the login as was able to remove the Connect grant in Securables.
I have seen this issue every once in a blue moon. It's driving me batty because I can do the "thing" using GUI tools but not using scripts that were created by pulling the name value from sys.server_principals.
Any thoughts on what could be causing this?
Viewing post 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply