You are the SQL administrator for your company. You manage two SQL Server 2008 instances named SQL_Prod and SQL_Test . The SQL_Test instance is used by application developers to test new applications. A developer wants to be able to view the error log files for SQL Server, SQL Agent, SQL auditing, and WindowsEvents using the Log File Viewer component in SQL Server Management Studio. You need to grant thedeveloper the appropriate permission. What should you do?
A.
Add the user’s account to the securityadmin fixed server role.
B.
Add the user’s account to the setupadmin fixed server role.
C.
Add the user’s account to the db_securityadmin fixed database role in all databases on SQL_Test.
D.
Add the user’s account to the db_accessadmin fixed database role in all databases on SQL_Test.
Explanation:
You should add the user’s account to the securityadmin fixed server role. Members of the securityadmin rolecan view the error log files for SQL Server, SQL Agent, SQL auditing, and Windows Events using the Log FileViewer component in SQL Server Management Studio. Because these error logs exist at the server level, youmust use a fixed server role to access them. You should not add the user’s account to the setupadmin fixed server role. Members of this role can add andremove linked servers. You should not add the user’s account to the
db_securityadmin or db_accessadmin fixed database role in all databases on SQL_Test . SQL Server error logs are not accessed on a per database basis. They are accessed atthe server level. Members of the db_securityadmin fixed database role can modify database role membershipand manage database permissions. Members of the db_accessadmin
fixed database role can manage databaseaccess for Windows logins and groups and SQL Server logins.Objective:
Monitoring and Troubleshooting SQL ServerSub-Objective:
Locate error information.References:
TechNet > TechNet Library > Server Products and Technologies > SQL Server > SQL Server 2008 > ProductDocumentation > SQL Server 2008 Books Online > Database Engine > Technical Reference > FeatureReference > SQL Server Management Studio F1 Help > Object Explorer F1 Help > Management Node (ObjectExplorer) > Log File Viewer