Thursday, May 8, 2014

How to change port number for SSAS(Analysis Service) in SQL Server 2008, 2008 R2?

Clustered Instance:

Please note that the clustered instance of Analysis service will always use the port 2383. Even though it will allow to change the port number but still it runs on 2383 port itself. SO we cannot make SSAS to use any user defined port.

Standalone Instance:

Search for the file named ‘msmdsrv.ini’ file in Config folder of installation folder. In this folder there will be a section

<port>0</port>

Here we need to replace ‘0’ ZERO with the port number we need. After changing restart the SQL services and SSAS will start using the port specified.




Thanks!!