The connection string to repository needs to be specified in the 9.0 server properties

  • Article

This Office product will reach end of support on October 10, 2017. To stay supported, you will need to upgrade. For more information, see , Resources to help you upgrade your Office 2007 servers and clients.

 

Topic Last Modified: 2016-11-14

This article describes an error that can occur when you use the Microsoft Office Project Server 2007 Cube Building Service to build or update the OLAP cube database.

Problem description

An error similar to the following appears in the Build Tracking Comments log when you are building or updating the OLAP cube database, during the stage when the database and cubes are being built:

Analysis Services session failed with the following error: Failed to connect to the Analysis Services server <AnalysisServicesServerName>. Error: The connection string to repository needs to be specified in the 9.0 server properties (see <DSO>...</DSO> section in msmdsrv.ini file from Analysis Services 9.0).

Possible causes

Any of the following things can cause this error:

  • In the Msmdsrv.ini file, the DSO section does not have the proper connection string.

  • The logon account for the Microsoft Office Project Server Queue service does not have access to the DSO folder.

  • The logon account for the Microsoft Office Project Server Queue service does not have permissions in SQL Server Analysis Services.

Solution

There are two possible solutions to the problem:

  1. Review the SQL Server Analysis Services DSO configuration settings by using SQL Server Management Studio. These settings are reflected in the Msmdsrv.ini file. For more information about editing the Analysis Services DSO configuration, see Requirements for using SQL Server 2005 Analysis Services with the Project Server 2007 Cube Building Service.

  2. Add the logon account for the Microsoft Office Project Server Queue service to the server role for the instance of Analysis Services.

    In SQL Server 2005 Analysis Services, a user in the OLAP Administrators group does not have the right to create databases, unlike SQL Server 2000 Analysis Services. You have to explicitly add the SSP Administrator account to the server role for the SQL Server 2005 Analysis Services instance. Members of the server role within an instance of SQL Server 2005 Analysis Services have unrestricted access to all Analysis Services objects and data in that instance.

    Add a member to the server role for an instance of Analysis Services

    1. In SQL Server Management Studio, connect to the instance of Analysis Services, right-click the instance name in Object Explorer, and then click Properties.

    2. Click Security in the Select a Page pane, and then click Add.

    3. In the Select Users or Groups dialog box, in the Enter the object names to select box, add one or more Windows users or groups.

    4. Click OK.

      Note

      By default, the members of the Administrators local group are members of the Analysis Services server role. However, their membership in this server role does not appear in the user interface.

    For more information about adding a user to the server role in SQL Server 2005 Analysis Services, see the MSDN article entitled Granting Server-Wide Administrative Permissions (https://go.microsoft.com/fwlink/?LinkId=91235\&clcid=0x409).

Download this book

This topic is included in the following downloadable book for easier reading and printing:

See the full list of available books at Downloadable content for Project Server 2007.