a.

Install Microsoft SQL Server 2005 Service Pack 1 (SP1) or a later service pack. For more information about how to obtain the latest service pack for SQL Server 2005, click the following article number to view the article in the Microsoft Knowledge Base:

913089 (http://support.microsoft.com/kb/913089/) How to obtain the latest service pack for SQL Server 2005

b.

Make sure that you are a member of the Server role on the Analysis Server. To add members to the server role for an instance of Analysis Services, follow these steps:

Note Members of the server role in an instance of SQL Server 2005 Analysis Services have unrestricted access to all Analysis Services objects and data in that instance. A member of the Analysis Services server role can add Microsoft Windows users and groups to the Analysis Services server role.

•

If you have a single server deployment of Project Server 2003 in which Project Server 2003, SQL Server 2005, and SQL Server 2005 Analysis Services are installed on one computer, go to step 3. You do not have to perform the procedure in step 2.

•

If you have a server farm deployment of Project Server 2003, follow these steps:

a.

Create a subfolder that is named DSO9 in the following folder:

C:\Program Files\Microsoft Sql Server\Mssql.Number\OLAP

Note Mssql.Number is the folder in which the SQL Server 2005 Analysis Services files are stored.

b.

Copy the Msmdrep.mdb file from a computer that is running a fully patched SQL Server 2000 Analysis Services to the DSO9 folder on the computer that is running SQL Server 2005 Analysis Services.

c.

Share the DSO9 folder, and then specify MSOLAPRepository$ as the share name for the shared folder.

d.

Assign Read access and Write access for the shared folder. Do this for the Local Administrators group or for any account that Project Server 2003 will use to connect to Analysis Services for processing.

The account that accesses Analysis Services from Project Server 2003 must be granted the appropriate permissions on the Analysis Services instance.

e.

Open the Msmdsrv.ini file, and then replace the contents of the <DSO> tag with the following code:

<DSO> <RemoteRepositoryConnectionString>Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\\ComputerName\MSOLAPRepository$\msmdrep.mdb;Persist Security Info=False</RemoteRepositoryConnectionString> <RepositoryConnectionString>Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Program Files\Microsoft SQL Server\MSSQL.Number\OLAP\DSO9\msmdrep.mdb;Persist Security Info=False</RepositoryConnectionString> <RemoteLocksDirectory>\\ComputerName\MSOLAPRepository$</RemoteLocksDirectory> <LocksDirectory>C:\Program Files\Microsoft SQL Server\MSSQL.Number\OLAP\DSO9</LocksDirectory> </DSO>

Note The Msmdsrv.ini file is located in the Path\Config folder. Make sure that you replace ComputerName in the code with the name of the computer that is running SQL Server 2005 Analysis Services.

The first time that you save the Msmdsrv.ini file, SQL Server 2005 Analysis Services encrypts the "ConnectionString" information. After this occurs, you cannot read the information when you open the file again. Therefore, you should keep a copy of the code in case you need it in the future.

f.

Stop and then restart the SQL Server 2005 Analysis Services service.