SSAS 2012 Access through the internet


  • Hi everybody,

    I'm trying to configure a SSAS acess through the internet using the underlying link

    I succeed in connecting to msmdpump.dll using my URL http://IP/SSAS/msmdpump.dll
    I get a 200 OK Status in my internet browser.
    Then I try to connect to the cube using Excel and the same URL.
    Excel sent me back an Error message "The following System Error occured" without any details

    I work on a Windows Server 2008 R2 Standard Server using IIS7 and SQL Server 2012.
    I use named instance on 2 ports 49XXX and 49YYY

    Does the TCP Port 2382 must be opened?

    Thanks for your help.


    • Edited by ms_bi_pete Thursday, July 04, 2013 9:09 PM
    Thursday, July 04, 2013 2:34 PM


  • Hi ms_bi_pete,

    The answer is No. By default, Analysis Services listens on TCP/IP port 2383. If you installed Analysis Services as the default instance, you do not need to specify any port in <ServerName> because Analysis Services knows how to listen on port 2383 automatically. However, you do need to allow inbound connections to that port in Windows Firewall. For more information, see Configure the Windows Firewall to Allow Analysis Services Access.

    If you configured a named or default instance of Analysis Services to listen on a fixed port, you must add the port number to the server name (for example, <ServerName>AW-SRV01:55555</ServerName>) and you must allow inbound connections in Windows Firewall to that port.

    If this issue still persists, please try to collect log information in Event Viewer.

    Best Regards,

    Elvis Long
    TechNet Community Support

    Thursday, July 11, 2013 6:02 AM