Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

My account, david, is in the Administrators group on a Windows 7 machine.

I am still having problems with programs that I should be able to use, such as SQL Server. Specifically, my account seems to not have correct permissions when I am working.

I know with an Administrator account I should have full access. How can I force my account (david) to act like an admin account and have full access to everything?

share|improve this question
Can you clarify where your permission problems lie? From how I read your question you can do everything but have incorrectly configured your SQL Server. – Tom Wijsman Mar 4 '11 at 11:01
up vote 2 down vote accepted

You might have run into the famous Windows 7 gotcha, where programs launched by Administrator are still executed with reduced privileges. This means that although you are administrator, you don't have full access.

The solution is to use "Run as administrator" on programs that need elevation (even though you are the administrator).

If that is indeed the problem, you might set the properties of the affected executables to be "Run as administrator", so elevation always occurs. (Or disable UAC, but that is a negative solution.)

share|improve this answer

Use the SQL Server Management Studio and set the correct permissions for your account David.

share|improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .