Weird problem altering logins with sysadmin account

  • 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?

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

Viewing post 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply