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.

Possible Duplicate:
Don’t have permission to access SQL Server Express 2008??

I have a remote PC with SQL Server 2008 setup and allowing remote connections.

I am an Admin user on the PC and have remotely connected to the SQL Server and I am trying to restore a database from backup but getting permissions denied for anything I try to do on the server!

I can add myself as a login to the SQL database but only with public server roles!

The server is setup to Log in as Local Account and I also have the SQL Server Browser running as well!

What am I doing wrong or missed??

share|improve this question

migrated from stackoverflow.com Aug 14 '09 at 0:59

This question came from our site for professional and enthusiast programmers.

marked as duplicate by splattne Aug 16 '09 at 13:49

This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.

    
what's the user you used to connect to sqlserver? –  Wael Dalloul Aug 13 '09 at 9:50
    
Exact duplicate of serverfault.com/questions/53645/… –  Dennis Williamson Aug 16 '09 at 11:57

1 Answer 1

Starting from SQL Server 2005 SP2 members of Administrators group are not added to sysadmin role on the server by default in case you're running Windows Vista or higher. Now specifying server administrator(s) is an additional step during SQL Server setup. In case you've missed it, there's a special 'SQL Server provisioning tool' that you can use later to add someone to sysadmin role.

share|improve this answer

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