Errors connecting to remote SSAS from Mgmt Studio

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

Analysis Services (2000)

Errors connecting to remote SSAS from Mgmt Studio

Author

Topic

arpanshah
Starting Member

1 Post

Posted - 2006-10-18 : 12:17:11

I really need help to understand why I can't connect to SSAS from a remote machine running SSMS or BIDS. Following is my setup:

SQLServer 2005 on a development server
Server Name: SQLWIN-1
Named Instance: SQLWIN1

If I am running management studio locally from the server machine I can connect to SSAS fine. However, when running from a remote machine the connection fails with the following errors:

TITLE: Connect to Server
------------------------------
Cannot connect to SQLWIN-1\SQLWIN1.
------------------------------
ADDITIONAL INFORMATION:
A connection cannot be made to redirector. Ensure that 'SQL Browser' service is running. (Microsoft.AnalysisServices.AdomdClient)
------------------------------
No connection could be made because the target machine actively refused it (System)

What I have already verified & tried:
SQL Browser service is running under NT Authority/Network Service account.
SSAS properties has local and remote connections radio button checked.
I even unabled anonymous login for SSAS on SQLWIN1

If I change the SQL Browser to run under the local system account, i get a slightly different error as follows:

TITLE: Connect to Server
------------------------------
Cannot connect to SQLWIN-1\SQLWIN1.
------------------------------
ADDITIONAL INFORMATION:
A connection cannot be made. Ensure that the server is running. (Microsoft.AnalysisServices.AdomdClient)
------------------------------
Unable to read data from the transport connection: An established connection was aborted by the software in your host machine. (System)
------------------------------
An established connection was aborted by the software in your host machine (System)

I am kinda stuck and don't know what else I can try.

Any help is appreciated. Thanks

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources