Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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

1 Answer 1

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

 
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.