You cannot build an OLAP cube in Microsoft Project Server 2002 (814139)
The information in this article applies to:
- Microsoft Project Web Access
- Microsoft Project Server 2002
SYMPTOMS 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 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. The last message appears in the Current Cube
Status section. CAUSEThis 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.RESOLUTION To resolve this problem, install SQL Analysis Service Pack
3:
- Visit the following SQL Server 2000 Service Pack 3 Web
page:
- Scroll down to the Files in this Download
section, and then click the Sql2ksp3.exe file.
- In the File Download dialog box, click
Save.
- In the Save As dialog box, specify a
location on your computer to save the file, and then click
Save.
- In the Download Complete dialog box, click
Open.
- In the Installation Folder dialog box,
click Finish. Click Yes to create the
C:\Sql3ksp3 folder.
- On the Desktop, right-click My Computer,
click Explore, browse to the C:\Sql2ksp3\X86\Setup folder, and
then double-click SetupSQL.exe.
- Follow the instructions on the screen to install the
service pack.
- Install SQL Analysis Service Pack 3. To do this, repeat
steps 1 through 8, with the following exceptions:
- In step 2, click the Sql2kasp3.exe
file.
- In step 7, browse to the C:\Sql2ksp3\Msolap\Install
folder, and then double-click Setup.exe to install SQL
Analysis Service Pack 3.
Note If you installed Project Server in a distributed configuration where Project Server and SQL Analysis Services are installed on different computers, apply Microsoft SQL Server Service Pack 3 (Sql2kasp3.exe) to update your Decision Support Object for SQL Analysis on your Project Server computer. 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:
324838
OLAP cube generation may not be successful in Microsoft Project Web Access
Modification Type: | Minor | Last Reviewed: | 1/7/2006 |
---|
Keywords: | KB814139 |
---|
|