Cannot connect to OLAP Server

M

MarkC

This can be caused by several problems.

1) If the Web Server and the SQL server are on different
boxes Analysis Services needs to be installed on the box
with the Web Server.

2) The Analysis Services (OLAP) Access Identity for the
web server to connect to the OLAP cube are not set. You
must run PSCOMPlus and enter the Username and Password to
connect to the OLAP cube. Drive Letter:\Program
Files\Microsoft Project Server\Bin\1033\ PSCOMPlus
-----Original Message-----
I went into the Enterprise options, and then to
the 'Update resource tables and OLAP cube' to create an
OLAP cube. The name of my analysis server was already in
the 'Server Name' field. So I went down and clicked on
the 'Update Now' button and it said 'Could not connect to
the OLAP Server'.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top