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.