Updated: 2009-12-10

For cube building, you can use SQL Server 2000 Analysis Services, SQL Server 2005 Analysis Services, or SQL Server 2008 Analysis Services. This article describes requirements for using SQL Server 2008 Analysis Services with the Microsoft Office Project Server 2007 Cube Building Service.

For information about requirements for SQL Server 2000 Analysis Services, see Requirements for using SQL Server 2000 Analysis Services with the Project Server 2007 Cube Building Service [ http://technet.microsoft.com/en-us/library/cc197489(office.12).aspx ] .

For information about requirements for SQL Server 2005 Analysis Services, see Requirements for using SQL Server 2005 Analysis Services with the Project Server 2007 Cube Building Service [ http://technet.microsoft.com/en-us/library/cc197552(office.12).aspx ] .

This article describes the following:

  • Install the Decision Support Object (DSO) client components on Project Server application servers   Describes how to correctly install the SQL Server components required on the application server in order to communicate with SQL Server 2008 Analysis Services.

  • Configure the Shared Services Provider (SSP) account to access SQL Server 2008 Analysis Services   Describes how to add the SSP account to the OLAP users group and as an administrator on SQL Server 2008 Analysis Services.

  • Configure SQL Server 2008 Analysis Services   Describes how to create the repository database through two options:

    • Create the repository database by creating a SQL Server 2008 database

    • Create the repository by using a SQL Server 2000 Microsoft Jet database

  • Grant the Analysis Services service account access to the Project Server Reporting database   Describes how to grant permissions to the SQL Server Analysis Services account to access the Reporting database, which is required by the cube building service.

  • Requirements for building and viewing cubes in Project Web Access   Describes how to install components that are required for creating and using Data Analysis views that use the OLAP cube data.

  • Port requirements for SQL Server 2008 Analysis Services   Describes port requirements for the traffic between the Project Server application server and SQL Server Analysis Services server.

  • Port requirement for Office Web Components   Describes port requirements for the Office Web Components when trying to view OLAP cube data by using Data Analysis views over an extranet.

  • Error Messages and possible solutions   Describes errors and possible solutions and workaround that can occur when configuring SQL Server 2008 Analysis Services with the Office Project Server 2007 cube building service.

Install the Decision Support Object (DSO) client components on Project Server application servers

Although Office Project Server 2007 can be used with Analysis Services in either SQL Server 2000, 2005, or 2008 versions, it was built primarily to be used with SQL Server 2000 Analysis Services. The Decision Support Objects (DSO) library included with Microsoft SQL Server 2008 enables programs written for Analysis Services in SQL Server 2000 to work with Analysis Services in SQL Server 2008. Office Project Server 2007 uses the SQL Server 2000 Analysis Services DSO library to create and manage OLAP cube data. The ability of SQL Server 2008 Analysis Services to be backwards compatible allows it to use the DSO model required by Office Project Server 2007 for OLAP cube management.

By default, the DSO library is installed by the SQL Server 2008 installation process. However, for the purposes of cube building, the DSO library must be installed on every server on which the Project Server application server is running. Therefore, on any server computer running Project Server application server where Analysis Services is not installed, you need to install the DSO library.

The way to install the DSO library is to get a set of redistributable packages included in the SQL Server 2005 Feature Pack. That set consists of:

  1. Microsoft SQL Server Native Client

  2. Microsoft SQL Server 2005 Management Objects Collection

  3. Microsoft SQL Server 2005 Backward Compatibility Components

Important Important:

Although this article involves SQL Server 2008 Analysis Services, it is important that you download these components from the Feature Pack for Microsoft SQL Server 2005 – December 2008 [ http://go.microsoft.com/fwlink/?LinkId=142288 ] (http://go.microsoft.com/fwlink/?LinkId=142288). At this time, do not use the feature packs for SQL Server 2008 to install and download these components, as those files will not allow you to build cubes in SQL Server 2008 Analysis Services with Project Server 2007.

Important Important:

Prior to installing the Microsoft SQL Server 2005 Management Objects from the Feature Pack for Microsoft SQL Server 2005 – December 2008 [ http://go.microsoft.com/fwlink/?LinkId=142288 ] (http://go.microsoft.com/fwlink/?LinkId=142288), you must install the Microsoft SQL Server Native Client from this same feature pack collection. It is important to install this component first.

Note Note:

If SQL Server 2008 Analysis Services is running on the Project Server application server (for example, a single-computer installation), then the DSO library will already be installed. In that configuration, you would not need to download and apply the Microsoft SQL Server 2005 Backward Compatibility Components.

Install the Microsoft SQL Server Native Client
  1. Browse to the Feature Pack for Microsoft SQL Server 2005 – December 2008 [ http://go.microsoft.com/fwlink/?LinkId=142288 ] (http://go.microsoft.com/fwlink/?LinkId=142288) download page.

  2. Click the X86 Package for th