Portfolio Analyzer connectivity

P

Pramraj Mangra

I have an issue with Portfolio Analyzer connectivity in Project Server 2003
from an office location which has a firewall. Other locations works fine.
Our installation has Analysis Services 2000 installed on a separate server.
I can connect with everything else, including Project Pro.
Interestingly, when I do a netstat -a on an EPM administrator machine which
is working, I am seeing that a direct connection is made with the Analysis
Services machine. Is this normal?
When I do the same thing on non-administrator machine I don't see this
connection.
Any assistance would be greatly appreciated.

Regards,
Pramraj

url:http://www.ureader.com/gp/1119-1.aspx
 
J

James Fraser

I have an issue with Portfolio Analyzer connectivity in Project Server 2003
from an office location which has a firewall. Other locations works fine.
Our installation has Analysis Services 2000 installed on a separate server.
I can connect with everything else, including Project Pro.
Interestingly, when I do a netstat -a on an EPM administrator machine which
is working, I am seeing that a direct connection is made with the Analysis
Services machine. Is this normal?
When I do the same thing on non-administrator machine I don't see this
connection.
Any assistance would be greatly appreciated.

Regards,
Pramraj

url:http://www.ureader.com/gp/1119-1.aspx
Click to expand...

This is normal and expected. SQL Server 2000 Enterprise Edition is
required to tunnel Analysis Services data through http. Then you can
specify an http:// address for the Analysis Server. Otherwise a direct
connection to the SQL Analysis Services is used, on some well-defined
ports that I don't recall at the moment.


James Fraser
 
Top