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.
|show 5 more comments|
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.