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).
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
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.
Incorrect format:
No comments:
Post a Comment