Server Fault is a question and answer site for system and network administrators. 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

Recently I have been having problems accessing local connection in my SQL Server Management Studio 2008.

I am connected to a network, and my account has administrator rights on all the computers. When I connect to SSMS\local, the only Logins available are BUILTIN\USERS and sa. I can't change this or reset the passwords because I don't have access.

I find this strange because Administrator group should be higher than Users group. Even if I log off and connect to the computer locally as Administrator I still have problems.

I've tried everything, the only thing that works is to change startup parameters in Configuration Manager and include -m. But if I add a new Login, it doesn't persist if I remove -m again.

Someone please help me!!!

share|improve this question

If you're relying on the builtin "Administrators" group membership to grant "sa" rights to a use be sure you're running SQL Management Studio elevated, otherwise your user isn't an "Administrator" and, ergo, won't have "sa" rights either.

share|improve this answer
nope..I'm running as administrator. – happygilmore Feb 28 '13 at 13:35
Hmm... Well, it was worth a shot. – Evan Anderson Feb 28 '13 at 13:47
thanks anyway, it's a real PITA :-( – happygilmore Mar 3 '13 at 9:34

Your Answer


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.