Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
Article ID: 814139 - Last Review: February 1, 2007 - Revision: 3.2
You cannot build an OLAP cube in Microsoft Project Server 2002
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.
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.
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:
- 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Â
(http://kbalertz.com/Feedback.aspx?kbNumber=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.
- Click Start, point to
Settings, click Control Panel, and then
double-click Add/Remove Programs.
- Click Microsoft SQL Server 2000, and then
click support information. In the Support
Info dialog box, examine the product version. If Microsoft SQL Server
2000 Service Pack 3 is installed, the version will be
8.00.760.
- Click Close, click Microsoft SQL
Server 2000 Analysis Services, and then click support
information. If Microsoft SQL Server 2000 Analysis Services Service
Pack 3 is installed, the version will be 8.00.760.
The error messages that are listed in the "Symptoms" section
of this article may also appear when the customer applies the hotfix that is
described in the following Microsoft Knowledge Base article:
812640Â
(http://kbalertz.com/Feedback.aspx?kbNumber=812640/
)
You cannot build an OLAP cube when scheduled in Microsoft Project Server 2002
If 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.
APPLIES TO
- Microsoft Office Project Web Access
- Microsoft Project Server 2002
Community Feedback System
Very often, it takes hours to solve a problem. Very often, you've looked high
and low, and have tried a lot of solutions. When you finally found it, chances
are, it was because someone else helped you. Here's your chance to give back.
Use our community feedback tool to let others know what worked for you and what
didn't.
Please also understand that the community feedback system is not warranted to be
correct, it's simply a system that we've built to let people try and help each
other. If something in a feedback response doesn't make sense to you, or you're
not comfortable making changes that the feedback talks about (like registry
edits), please consult a professional.
Thank you for using kbAlertz.com Feedback System.
-- Scott Cate
Be the first to leave feedback, to help others about this knowledge base
article.
(Optional) Name
(Optional)
Public URL Or Email
Comments
No
HTML -- Text Only Please