Data Analysis view creation page can't connect to server.....

[PedroJose]

Hi,

I got to the data analysis view definition page from my laptop from PWA2007
and it tells me that it can't connect to the analysis services server (I have
full administrator rights). When I do this (data analysis view definiton
page) from the server itself (the physical machine) it works fine, I can
connect and see all the cubes etc. Does nayone now why this is happening?????

Please help.

Thanks.

 

[James Fraser]

Hi,

I got to the data analysis view definition page from my laptop from PWA2007
and it tells me that it can't connect to the analysis services server (I have
full administrator rights). When I do this (data analysis view definiton
page) from the server itself (the physical machine) it works fine, I can
connect and see all the cubes etc. Does nayone now why this is happening?????

Please help.

Thanks.

You may have a security problem or be missing certain pieces of
software:
1) Make sure that "Access Data Sources Across Domains" is enabled in
IE security settings for the zone of the Project Server.
2) Make sure that "Microsoft Office Web Components" & "Microsoft SQL
Server 2005 Analysis Services 9.0 OLE DB Provider" are installed on
the client computer.

See the section "Requirements for building and viewing cubes in
Project Web Access" in this document for more details:
http://technet2.microsoft.com/Offic...701c-4b02-89d7-e094e9cb7dcd1033.mspx?mfr=true


James Fraser

 

[Gary L. Chefetz [MVP]]

I'd like to add a couple items to James' list:

1) Make sure that "Access Data Sources Across Domains" is enabled in
IE security settings for the zone of the Project Server.
2) Make sure that "Microsoft Office Web Components" & "Microsoft SQL
Server 2005 Analysis Services 9.0 OLE DB Provider" are installed on
the client computer.

3) Make sure that your Project Server instance is in trusted sites
4) Set trusted sites security level to low
5) Upgrade to MSXML 6.0 if you are running an OS prior to Vista
6) Add yourself and other users to the Project Server View OLAP Data Role in
Analysis Services

When you logon to the server console with a server administrator account,
you bypass the authentication requirements necessary for a workstation
logon.

--

Gary L. Chefetz, MVP
MSProjectExperts
For Project Server Consulting: http://www.msprojectexperts.com
For Project Server FAQS: http://www.projectserverexperts.com