Changing Ports for SQL Server Analysis Services

Here’s all what you might be interested to know about the configuration and customization of port configured for SQL Server Analysis Services-

How to check the Port number configured for SQL Server Analysis Services:
a) Open Task Manager and get the Process Id (PID) for msmdsrv.exe.
b) Open command Prompt type netstat /abo >>c:\output.txt .
c) Look for the PID in output file and corresponding TCP IP:Port information for same PID.
d) To confirm whether you got right Port number, Open Management Studio and connect to AS using IP Address:Port Number (For example:

How to change Port for SSAS Service:
1) Non-clustered environment (Default Instance or Named Instance):
You can configure a named instance to run under a specified port by changing the Port property for the Analysis Services instance to a specified value by using SQL Server Management Studio (this is an advanced property) or by editing the Port server property (<Port>0</Port>) in Msmdsrv.ini file directly (in the ../OLAP/Config folder). A value of zero (the default value) means that Analysis Services dynamically assigns the port at startup.

2) Clustered environment (Default Instance or Named Instance):
SSAS will start listening on all Public IP addresses of the cluster group using the default port (2383). Any alternate port configuration is ignored.  All clustered SSAS instances, no matter whether they were originally installed as default or named instance, behave like default instances and listen on port 2383. The only supported way to connect to a clustered SSAS instance is to use the “virtual server name” (also called network name) – Usage of the instance name like in  “VirtualServerName\InstanceName” is not supported.

Happy Learning!

Aman Kharbanda