Connection to OLAP server failed

[kumud wadhwa]

I have installed project server 2003(sp2a) and sql 2000(sp3a) +analysis
server on two machines in secure zone.

I also installed PDO of analysis server on PROJECT server machine.

WSS is on another server i.e in DMZ zone using PIX Firewall.

When I try to build cupe i get following error message even thogh
projectadmin is a member of OLAP administrators on both machines.

I get following as the error message in event log.

Unable to connect to the registry on the server (ccggsqdb), or you are not a
member of the OLAP Administrators group on this server.' Error Number :
'-2147221455.

Could somebody help to resolve this issue.

Regards,

 

[Aaron Tamblyn]

Check the following:

1. You are running the data objects for Analysis Services on the Web Server
2. You have a service account set up for the OLAP connection. This account
needs to be a member of the 'OLAP Admininstrators' local group on both the
front end web server and on the database server.
3. You have migrated the Analysis Services Repository as detailed in the
Post Installation steps section in the installation guide. You need to
operate with a migrated repository in a multi server set up.
4. That the COM+ component for the OLAP connection is running under the
identity of the service account mentioned in step 2 above. You check this by
opening Component Services from Administrative Tools on the Web Server. Open
the Components folder and select the OLAP connection package. Right click on
the package and select properties. In the properties there is an Identity
tab that shows the account the component runs under. You can reset the
identity by using PSCOM+ which is a Project Server tool.
5. If you can't connect you could try installing the client tools for
Analysis Services on the Front end server. If they won't connect you likely
have an addressing / blocking problem in your network. If the firewall is
between the database server and the front end server then you also need to
look at ensuring that the Analysis Services port/s are open. Refer to the
following article on Analysis Services ports
http://msdn2.microsoft.com/en-us/library/ms174937.aspx

Best of luck. Let us know how you got on.

 

[kumud wadhwa]

Thanks a lot for sending a detailed checklist.

I checked for all the points mentioned hereunder from Sno 1-4 . They were
all correctly defined.

Then I tried to connect to another OLAP server and again got the same error.

What I missed was running sp3 of analysis services on Front end server.

I installed sp3 of sql 2000 analysis services on front end project server
and my problem was solved.

Thanks a lot for helping me .

Regards