Analysis Service Not Working

[Bryan]

Hi,

We are having an issue getting the analysis service working in our
environment. We are running Project Server 2007 with SP2 and all
subsequent CUs. We have SQL Server 2000 installed on the same
server. When I try to create the Data Analysis view, I receive the
following error:

"Failed to connect to the Analysis Services server. Verify the server
name and try again."

I have it set to the default server. I can also successfully build
the OLAP cubes and access them through an Excel data connection. We
have gone through the entire TechNet article and followed it to the
letter.

We have been trying to figure this out for a few weeks with no luck.

Any help is truly appreciated!

 

[Ben]

Hi Brian,

Make sure you have installed the relevant the ASOLEDB client. There is lots
on info around on this, check Brian's site
http://blogs.msdn.com/brismith/arch...ver-2005-analysis-service-building-cubes.aspx

Note that you'll need the AS2000 client....