which fixed server role should you add the other administrator?

You are a SQL administrator for your company. You manage all of your company’s SQL Server 2008 computers.An administrator for another department needs access to the SQL Server 2008 computers that you manage. Youwant to allow the other administrator to add and remove linked servers without granting the administratorunnecessary permissions.
To which fixed server role should you add the other administrator?

You are a SQL administrator for your company. You manage all of your company’s SQL Server 2008 computers.An administrator for another department needs access to the SQL Server 2008 computers that you manage. Youwant to allow the other administrator to add and remove linked servers without granting the administratorunnecessary permissions.
To which fixed server role should you add the other administrator?

A.
sysadmin

B.
serveradmin

C.
setupadmin

D.
diskadmin

Explanation:

You should add the other administrator to the setupadmin fixed server role. This role can add and remove linkedservers on a SQL Server 2008 computer. You should not add the other administrator to the sysadmin fixed server role. This role would grant the otheradministrator all rights on the server. You should not add the other administrator to the serveradmin
fixed server role. This role does not grant themember the permission to add and remove linked servers. Members of this role can change server-wideconfiguration settings and reboot the server. You should not add the other administrator to the diskadmin fixed server role. This role does not grant themember the permission to add and remove linked servers. Members of this role can manage disk files.

Objective:
Managing SQL Server Security

Sub-Objective:
Manage logins and server roles.

References:
TechNet > TechNet Library > Server Products and Technologies > SQL Server > SQL Server 2008 > ProductDocumentation > SQL Server 2008 Books Online > Database Engine > Security and Protection > Identity andAccess Control > Server-Level Roles



Leave a Reply 0

Your email address will not be published. Required fields are marked *