cannot add a user to sysadmin role in SQL Server

Posted by George2 on Server Fault See other posts from Server Fault or by George2
Published on 2009-08-01T12:07:35Z Indexed on 2011/11/26 17:57 UTC
Read the original article Hit count: 457

I am using SQL Server 2008 Management Studio. The current logon account belongs to machine local administrator group. I am using Windows Integrated Security mode in SQL Server 2008.

My issue is, after log into SQL Server Management Studio, I select my login name under Security/Logins, then select Server Roles Tab, then select the last item -- sysadmin to make myself belong to this group/role, but it says I do not have enough permission. Any ideas what is wrong? I think local administrator should be able to do anything. :-)

© Server Fault or respective owner

Related posts about sql-server

Related posts about security