Curtis Johnstone

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Ā http://support.microsoft.com/kb/946686).

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
Share and Enjoy:
  • Print this article!
  • Digg
  • Sphinn
  • del.icio.us
  • Facebook
  • Mixx
  • Google Bookmarks

No Comments »

No comments yet.

RSS feed for comments on this post. TrackBack URL

Leave a comment

Powered by WordPress