Article ID: 814139 - View products that this article applies to.
This article has been archived. It is offered "as is" and will no longer be updated.
When you try to generate an OLAP cube, you may receive one of the following error messages:
VBScript: Microsoft Project Web Access could not connect to the OLAP server specified.
Error Code 9104
The last message appears in the Current Cube Status section.
The cube scheduled to be built on date at time failed. (-2147221455) Unable to connect to the registry on the server SQL Analysis server name, or you are not a member of the OLAP Administrators group on this server.
This behavior may occur if you have applied the Microsoft SQL Server Service Pack 3, but you have not applied the matching Service Pack for SQL Analysis Services.
To resolve this problem, install SQL Analysis Service Pack 3:
Note Additionally, in Microsoft Project Server Web Access, you must migrate the Analysis Services repository to a Microsoft SQL Server database and grant permissions to the Microsoft Project Server\Bin\1033 folder. For more information about how to migrate the Analysis Services and grant the necessary permissions to the Microsoft Project Server\Bin\1033 folder, click the following article number to view the article in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/324838/ )OLAP cube generation may not be successful in Microsoft Project Web Access
To determine if Microsoft SQL Server 2000 Service Pack 3 and SQL Server 2000 Analysis Service Pack 3 have been installed, follow these steps: Note Because there are several versions of Microsoft Windows, the following steps may be different on your computer. If they are, see your product documentation to complete these steps.
812640If the steps in the "Resolution" section of this article do not resolve the issue, see the resolution method that is in the Project Server Help file.
(http://support.microsoft.com/kb/812640/ )You cannot build an OLAP cube when scheduled in Microsoft Project Server 2002