Remove “Restricted User” in SQL Server 2008

Le Kevin

software engineer, photographer

You may also like...

3 Responses

  1. Matt says:

    Msg 5011, Level 14, State 5, Line 2
    User does not have permission to alter database ‘DatabaseName’, the database does not exist, or the database is not in a state that allows access checks.
    Msg 5069, Level 16, State 1, Line 2
    ALTER DATABASE statement failed.
    Msg 5011, Level 14, State 5, Line 1
    User does not have permission to alter database ‘DatabaseName’, the database does not exist, or the database is not in a state that allows access checks.
    Msg 5069, Level 16, State 1, Line 1
    ALTER DATABASE statement failed.

  2. Matt says:

    TIP: Remember to update all instances of “DatabaseName” in the query, not just the first one ;). Silly mistake.

  3. Thoko says:

    Thank you… it worked

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.