70-281 Planning, Deploying, and Managing an Enterprise Project Management Solution Training Course

Demo Question 7.

You are the administrator of the Microsoft Enterprise Project Management solution for EliteCertify.com. EliteCertify.com implements Microsoft Office Project Server 2003. Project Server and Microsoft SQL Server 2000 are located on the same subnet. Client workstations for Project Server are on a different subnet. You back up the Project Server database each night. The SQL Server server that hosts the Project Server database experiences a hard drive failure. You build a replacement SQL Server server and restore the data. Users report that they cannot connect to Project Server by using either Microsoft Office Project Professional or Microsoft Office Project Web Access. You attempt to access Project Web Access by using the Administrator account. You receive an error notification that states that you are unable to log on the project server. You must ensure that users can connect to the project server by using both Project Professional and Project Web Access. What should you do?

A. Delete and recreate the local accounts for Microsoft Windows SharePoint Services and OLAP. Add the OLAP administrator account to the OLAP Administrators group. Add both accounts to the Administrators group.
B. Use PSComPlus.exe to delete and recreate all identities.
C. Add the MSProjectServerUser and MSProjectUser users and appropriate roles to the restored Project Server database.
D. Reconfigure the properties of SQL Server to enable TCP/IP protocol connections.


Display Answer

Answer: C

Explanation: Each database role defines a set of users and groups and the access they share. A database role can be assigned to any cube and any data mining models in the database. This action grants users access to the cube or mining model if they have been assigned to that role. It also creates a cube role or mining model role with the same name as the database role. A cube role applies to only a single cube. The default values for a cube role are derived from the database role of the same name. Some of these defaults can be overridden in the cube role. In this case, the specifications in the database role are not the specifications applied to users in the role who access the cube. To determine the specifications that are used, see the cube role. To ensure connectivity you should add the two groups of users with the appropriate roles to the restored Project Server database. Reference: Microsoft Training and Certification: Microsoft Official Curriculum: Planning, Deploying, and Managing an Enterprise Project Management solution; Delivery Guide, Course Number 2732A, Module 9: Configuring and Managing Views and Security, Microsoft Press, Redmond, 2003, p. 28