pwa an data analysis publishing

[Jose X Perez]

Hi everyone,
I have a project server 2007 sp1 with SQL 2005 server installed in server
named serverepm.domain.com
the pwa address is http://serverepm.domain.com:8080/project for the intranet.
but i publish the service to the internet, with the name
http://pwa.domain.com:8080/project , y publish the port 80, 8080, 443 in
order to view the site of project, everythig works fine but i cant see the
data analysis views, there is an error that the conection is not abailable.
Now i open the port 2725 like sais in the address
http://technet.microsoft.com/en-us/library/cc197469(TechNet.10).aspx
but when i try to access is still an error, when i try to generate the cube
with the name serverepm it is fine but, even if i can ping the name pwa, it
shows error for this name,

Thanks for your help.

Jose X Perez

 

[Gary L. Chefetz [MVP]]

I'm not 100% certain this is true in SQL 2005, but in previous versions you
needed enterprise edition to expose Analysis services via http. Which
version are you running?

--

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

 

[Jose X Perez]

Im running sql 2005
Thanks for your answer, i try the link
http://www.microsoft.com/technet/prodtechnol/sql/2005/httpasws.mspx

so in the cube bluilding i write serverepm.domain.com as teh analisis revice
server and in the extranet address http://pwa.domain.com/olap/msmdpump.dll

the only thing i must do, in order to make this work, is change the user for
the anonymous acces to one with access to the cube.

And now everything is fine