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