Elevate User Permissions

Scenario: I’ve recently came across a user that had SQL on a server. The user was on the instance, but they had limited permissions. In essence this created a user that could login the SQL engine but had no access to the databases or the ability to add permissions to their account even though the account was a local administrator.

Here are the steps I took to elevate the user’s privileges:

  1. Start the instance in Single User Mode:
  2.  

  3. Grant user new permissions:
  4. Restart SQL in “normal” mode and login through Management Studio

It’s that simple :)

**I feel it is important to note that the user performing the SQLCMD query must be a local administrator.

Leave a Reply

Your email address will not be published.

HTML tags are not allowed.