Curtis Johnstone Curtis Johnstone's Personal Blog

August 15, 2012

How to Check Whether a User has Microsoft SQL Administrator Permissions

Filed under: Uncategorized — admin @ 11:38 am

Microsoft SQL has a fixed system administrator role named “sysadmin“.

If a Windows user (credentials) has this role, they have system administrator rights.

The sysadmin role is per SQL instance, not per deployed SQL “server”.

To check whether a user has sysadmin rights to a particular SQL instance, follow these steps (as outlined inĀ

I will summarize them here with a couple of slight modifications:

  1. Start SQL Server Management Studio.
  2. Connect to the SQL Instance.
  3. Expand the Security node, and then click Logins.
  4. Find the Windows User and right-click the user’s name, and then click Properties.
  5. Click the check-boxes to give them these two roles:
    • sysadmin
    • public

No Comments »

No comments yet.

RSS feed for comments on this post. TrackBack URL

Leave a comment

Powered by WordPress