PWA 2007 : You must have the valid Analysis Service database name

[Robert]

Hello,

I created succesfullty a cube, then I'm trying to build my first new view
with the type Data Analysis.
But in the "Analysis Service Database to be created" pick list, I don't find
my newly created database. I get the error:
"Failed to connect to the Analysis Services server. Verify the server name
and try again"
NB : my config is a small farm on only one server, with SQL Server 2000.
Thanks for your help

 

[Gary Chefetz]

Robert:

If you're not connecting to the AS, you need to solve that problem first.
Make sure that you've read the following:

http://technet.microsoft.com/en-us/library/cc197489.aspx

 

[Gary Chefetz]

Robert:

SQL Analysis Services is a separate installation from SQL Server. Did you
choose the basic install when you installed Project Server, rather than
choosing a full farm installation. If so, you do not get Analysis services
with this packaged installation.

 

[Robert]

Gary,

I installed a full (small) farm. If I go to the Analysis Manager (SQL 2000)
I can find the database I created while building the OLAP cube.
But I don't have any SQL Server Analysis Services (MSSQLSERVER)
Any idea?
Thanks for your help