Error message when you try to build an OLAP cube in a deployment of Project Server 2003 that uses SQL Server 2005 Analysis Services: "Could not connect to the OLAP server specified" (921116)

RESOLUTION

How to obtain the hotfix

1. On the computer that is running SQL Server 2005 Analysis Services, install Microsoft SQL Server 2005 Service Pack 1 (SP1). 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 How to obtain the latest service pack for SQL Server 2005

2. Use one of the following methods, as appropriate for your situation:
   • 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:
     1. Start Microsoft Internet Explorer, and then visit the following Microsoft Web site:

        http://www.microsoft.com/downloads/details.aspx?FamilyID=df0ba5aa-b4bd-4705-aa0a-b477ba72a9cb&DisplayLang=en

     2. On the computer or computers that are running the Project Server Views Notification Service, download and then install the following programs.
        
        Note Install these programs in the order in which they are presented.
        • Microsoft .NET Framework 2.0
          
          Note Install .NET Framework 2.0 only if it is not already installed on the computer.
        • Microsoft Core XML Services (MSXML) 6.0
        • Microsoft SQL Server Native Client
        • Microsoft SQL Server 2005 Management Objects Collection
        • Microsoft SQL Server 2005 Backward Compatibility Components
          
          Note When you install SQL Server 2005 Backward Compatibility Components, you have to install only Decision Support Objects (DSO). You do not have to install the other components.
3. On the computer that is running SQL Server 2005 Analysis Services, follow these steps:
   1. 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.
   2. Copy the Msmdrep.mdb file from a computer that is running SQL Server 2000 Analysis Services to the DSO9 folder on the computer that is running SQL Server 2005 Analysis Services.
   3. Share the DSO9 folder, and then specify MSOLAPRepository$ as the share name for the shared folder.
   4. Assign Read access and Write access to the OLAP Administrators group for the shared folder.
   5. 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.
      
      Additionally, keep a backup copy of the code separate from the Msmdsrv.ini file. SQL Server 2005 Analysis Services overwrites the file by using an encrypted version of the connection strings when SQL Server 2005 Analysis Services starts.
   6. Stop and then restart the SQL Server 2005 Analysis Services service.
4. Log on to Project Web Access 2003, and then build an OLAP cube. When you build the OLAP cube, specify the computer that is running SQL Server 2005 Analysis Services on the Update resource tables and OLAP cube page.