In SQL Server 2005 to administer all aspects of SQL is there any way a non local administrator can do this? We are trying to remove the DBAs from being local administrators over the SQL server machines in SQL 2005, we were able to do this in SQL 2000 but SQL 2005 is not working correctly.
We want to make the DBAs a member of local power users and assign the specific rights for it. Can this be done, if so how? is there a document I can reference somewhere.
Hi,
yes sure. Local administrators are automatically in the sysadmin group. YOu can sure remove them from the group if you don′t want them to have access to the server. On the other side, you can grant any role to a individual role, also the serverrole sysadmin. So put the "SQL Administrators" in a special Windows group and add this group to the serveradmin role. That should be fine for you.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
No comments:
Post a Comment