Remote Connection to SSAS

  • When I try to connect to Analysis Services by browsing for the machine, the "Network Servers" tab isn't even in the dialog. The "Local Servers" tab is. This is true across all 5 machines on which I have installed Sql Server Management Studio 2008. The same problem does not exist for the Database Engine; there, the Network Servers tab is available and works correctly. If I ignore the browser and type in the hostname, it times out saying the host failed to respond, despite the fact that I have started the AS service and opened the necessary ports on the server, and added my AD user the AS admin role. I have searched the docs and googled for hours and can't find any hint. Can someone please put me out of my misery? It is extremely frustrating to not be able to make any progress with Analysis Services because of this most basic issue.

    Thanks for you help!

  • Jeff Jordan (5/11/2009)


    When I try to connect to Analysis Services by browsing for the machine, the "Network Servers" tab isn't even in the dialog. The "Local Servers" tab is. This is true across all 5 machines on which I have installed Sql Server Management Studio 2008. The same problem does not exist for the Database Engine; there, the Network Servers tab is available and works correctly. If I ignore the browser and type in the hostname, it times out saying the host failed to respond, despite the fact that I have started the AS service and opened the necessary ports on the server, and added my AD user the AS admin role. I have searched the docs and googled for hours and can't find any hint. Can someone please put me out of my misery? It is extremely frustrating to not be able to make any progress with Analysis Services because of this most basic issue.

    Thanks for you help!

    There is no Network Servers tab for SSAS to the best of my knowledge. Is this a named instance of SSAS? Do you have the browser service running? If so, check the contents of the msmdredir.ini file at C:\Program Files\Microsoft SQL Server\90\Shared\ASConfig.

  • Thanks for the reply. No, this is not a named instance. I'm just trying to remotely connect to SSAS on another server. I guess that is just not possible.

  • Jeff Jordan (5/11/2009)


    Thanks for the reply. No, this is not a named instance. I'm just trying to remotely connect to SSAS on another server. I guess that is just not possible.

    You should be able to type the name of the host; i.e. Object Explorer -> Connect -> Analysis Services

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply