What is the minimum permission required in order to access the Project Server Reporting Database for the Cube Generation Service for the SQL Server Analysis Services account?
A.
Serveradmin
B.
Sysadmin role
C.
DB_DataReader role
D.
Diskadmin
Explanation:
In Office Project Server 2007, the account running the SQL Server Analysis Service service is granted direct access to the Reporting database in the SQL Management Studio. In order to access the Project Server Reporting Database for the Cube Generation Service, the minimum permission required is the DB_DataReader role. You must grant this permission to the SQL Server Analysis Services service account. Answer option B is incorrect. Sysadmin roles have complete control over the database functions. Answer option A is incorrect. Serveradmin roles can change server configurations, and reboot the server. Answer option D is incorrect. Diskadmin roles can only manage disk files.