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

I am pretty newbie on sqlserver. I just want to logon by Management Studio on a sqlserver just for backup a db. But it seems that I haven't enough permissions because I am guest. Anyone could explain me how to logon as admin ? I am local and domain admin and the sqlserver 2008 was been installed just for a wsus server. Thank you.

share|improve this question
    
I assume that you are logged-in as administrator, but SSMS keeps telling you that you do not have all the required permission. Did you try to right-click the SSMS icon and choose "Run as administator"? –  MBu Jun 24 '13 at 16:58
    
"Run as administrator" doesn't do anything for actually logging into SQL. It just elevates the SSMS process client side. The authentication token sent to SQL Server is the same. –  squillman Jun 24 '13 at 17:36
    
hopefully it was as easy as doing a run as admin, but if not and you are now responible for the db and you don't know the pw and or account that was given access you'll need to bring the service up in single user mode to correct this issue. –  tony roth Jun 24 '13 at 17:47
    
@squillman actually, if you put Domain Admins or the local Administators group into the SQL Server admins during installation, then Run As Administrator will, indeed do something. UAC will strip either of those memberships out of the logged in user's token. Running as administrator will run SSMS with that token in place, allowing a login where it was denied before. Of course, this is why you don't use those groups in that field, but that's another story :) –  MDMarra Jun 24 '13 at 18:25
    
The WSUS setup is a restricted SQL express setup...I'm sure there's documentation on how it's set up someplace. –  Nathan C Jun 24 '13 at 18:36

1 Answer 1

When you install SQL Server, there was a screen where you select a user or group to be administrators on that SQL Server instance. You must log in with an account that was granted that permission. Being a local admin on a server does not give you permission to MS SQL Server unless that group is explicitly added.

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.