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 byms_bi_peteThursday, July 04, 2013 9:09 PM
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.
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.