Wednesday, August 26, 2015

How to change the SSAS Port number

SSAS default instance or clustered instance (regardless named instance or not) default to 2383.

For SSAS named instance in standalone environment, default port is high port, and SQL Server Browser Service Listening on TCP 2382.

To change the port:

Edit file “<Instance Name>\OLAP\Config\msmdsrv.ini”, change the port number from “0” to desired value. (3034 in our case).

image

Don't forget to configure your firewall to allow incoming requests on TCP port 3034.

netsh advfirewall firewall add rule name="SQL Server Analysis Services (tcp-in) on 3034" dir=in action=allow protocol=TCP localport=3034 profile=domain

Restart the SSRS Service

image

C:\Users\administrator.DBAGLOBE>tasklist | findstr msmdsrv.exe
msmdsrv.exe                   1084 Services                   0     34,828 K

C:\Users\administrator.DBAGLOBE>netstat -nao | findstr 1084
  TCP    0.0.0.0:3034           0.0.0.0:0              LISTENING       1084
  TCP    [::]:3034              [::]:0                 LISTENING       1084

Connect to the SSAS using format “machinename:port” format, instead of “instancename:port” format.

image

Incorrect format:

image