Analysis Services connection "No Go" -- sql server (alternate)

wwhite NO[at]SPAM slp3d.com
7/20/2004 9:16:43 AM

Attempting to register (from a Win XP Pro machine) to my SQL Server
2000 machine (Win 2K Server), via Internet (http), error says

"Errors occurred while connecting to 'mysqlserver'.
Cannot open connection to Analysis server 'mysqlserver'.
Network error 'mysqlserver'
Do you still want to register this server?"

Query Analyzer and Enterprise Manager connected right up the first
time, and have worked AOK ever since.

I installed Analysis Services last night, and want to connect
remotely, via Internet.

Does anyone have suggestions?

Simon Hayes
7/21/2004 8:07:38 PM

[quoted text, click to view]

One possible explanation is that you have a firewall which is blocking
access to the Analysis Services port (2725), but allowing access to the
MSSQL port (1433). I guess you're connecting via a VPN, since exposing a
database server directly to the internet isn't good practice, so you may
have to look at the ports which your VPN configuration allows.

Simon

sql server (alternate) : Analysis Services connection "No Go"