Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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
1  
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

2 Answers 2

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

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.