Could not connect to the OLAP server specified

D

Didier Maignan

We have setup Project server on a different machine as SQL
server and it works. But Analysis services was not
installed. So we did it later (Service PAck 3 also) on the
SQL machine and now we try to built it from PWA, but we
have a message 'Could not connect to the OLAP server
specified', the log seems to show that the user is not
allowed to access to the Analysis. We used PScomplus.exe
and allowed the user with a "domain\username" declaration
on OLAP services. The com pllus works well on the Project
but it does not help.

Didier Maignan
 
G

Gary Chefetz [MVP]

Didier:

When accessing OLAP services across machines, the Project Server machine
must have the SQL Decision support objects installed. To install these,
select the client tools menu item from the SQL Server installation splash
screen. There are post installation steps that must be completed as well.
These are explained in the installation guide under "After you install
Project Server." You'll should migrate the repository after you install
Analysis Services and create and grant access to cube roles after you've
built the cube for the first time.

--
Gary Chefetz [MVP]
http://www.msprojectexperts.com
"We wrote the book on Project Server"

*** Remember to look for line breaks in links posted to the news group, use
cut and paste for these.
 
O

Omar Hossain

Did you add the "Useraccount" to the OLAPADmin group on
the SQL Server box? Otherwise it will not be able to
connect and re-create the cubes via the COMPlus apps.
 
E

Ed Hellyer

Did you install the OLAP connectivity components (only).

You will need the OLAP install CD and select client
connectivity components only. (Or some words to that
effect)

Ed.
 
Top