Updated: 2009-04-23
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 2005 Analysis Services with the Microsoft Office Project Server 2007 Cube Building Service.
Service pack requirements
In order for SQL Server 2005 Analysis Services to function correctly with the Office Project Server 2007 Cube Building Service, you must apply SQL Server 2005 Service Pack 1 or higher.
Install the DSO client components on Project Server application servers
Although Office Project Server 2007 can be used with either Analysis Services in SQL Server 2000 or SQL Server 2005, it was built primarily to be used with SQL Server 2000 Analysis Services. The Decision Support Objects (DSO) library included with Microsoft SQL Server 2005 enables programs written for Analysis Services in SQL Server 2000 to work with Analysis Services in SQL Server 2005. 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 2005 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 2005 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 for you to install DSO is by getting a set of redistributable packages included in the SQL Server 2005 Feature Pack. That set consists of:
- Microsoft SQL Server Native Client (sqlncli.msi)
- Microsoft SQL Server 2005 Management Objects Collection (sqlserver2005_xmo.msi)
- Microsoft SQL Server 2005 Backward Compatibility Components (SQLServer2005_BC.msi)
These components can be downloaded from the Feature Pack for Microsoft SQL Server 2005 – December 2008
Always check for the most recent version, as feature packs are released periodically.
If SQL Server 2005 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
- Go to the Feature Pack for Microsoft SQL Server 2005 – December 2008
- Click the X86 Package for the Microsoft SQL Server Native Client (sqlncli.msi).You can select X64 Package if you are using the 64-bit version of SQL Server 2005 Analysis Services.
- Click Run to start the download.
- Click Run to start the installation.
- On the Welcome to the Microsoft SQL Server Native Client Setup page, click Next.
- On the License Agreement page, select I accept the terms of this license agreement, and then click Next.
- On the Registration Information page, enter your name and company. Click Next.
- On the Feature Selection page, verify that both features (Client Components and SQL Server Native Client SDK) have this option selected: This feature, and all subfeatures, will be installed on local hard drive. Click Next.
- On the Ready to Modify the Program page, click Install.
- After the installation is done, click Finish.
Install the Microsoft SQL Server 2005 Management Objects Collection
- Click the X86 Package for the Microsoft SQL Server 2005 Management O