Share via

SQL Server Analysis Services Port (SQL 2005 / 2008)

  • Article

Default Port:2383

You can change default Port for AS in msmdsrv.ini file of the Instance.
Port Used by SQL Server Browser Services for SSAS is 2382

How to determine on which port AS is running?

-Open Task Manager Get the PID for msmdsrv.exe

-Open command Prompt type netstat /ao >>c:\output.txt

-Look for the PID in output file and corresponding TCP IP:Port information for same PID

-To confirm whether you got right Port number, Open Management Studio and connect to AS using IP Address:Port Number (192.168.1.1:5585)

How to change Port for AS Services (2005 & 2008)?

-In Clustered environment, AS can listen only on Port Number 2383.

For standalone Default or Named Instance you can change port number in msmdsrv.ini file (<Port>0</Port>)

Caveat:

SQL Server Bowser is enumerating all SSAS instances and will provide connection information for them.

Imp: Not any default instance information is handled by the SQL Server Browser which means, if you’re using a default instance with an alternate port, you will need to provide it to the client application; SQL Browser will not be able to forward it at connection time.

SQL Server Browser will only provide the connection information for visible SSAS named instance.

How AS Port is Determined in Standalone or Clustered Environment?

What if I have multiple nic card on a box, how exactly SSAS will Listen?

-SSAS as a Standalone Instance

Default instance

SSAS will start listening on all IP addresses of the box using the port specified in the msmdsrv.ini file or the default port (2383) if “0” specified.

Named instance

SSAS will start listening on all IP addresses of the box using the port specified in the msmdsrv.ini file or an available port provided by the system if “0” specified.

-SSAS as a Clustered Instance (Default Instance or Clustered Instance)

SSAS will start listening on all IP addresses of the cluster group using the default port (2383). Any alternate port configuration is ignored.

Imp: In clustered environment AS can listen only on Port Number 2383, manual setting in msmdsrv.ini file will be ignored.

On same box you can’t run standalone and clustered instance:

Related Links:

How to: Configure Windows Firewall for Analysis Services Access
https://msdn.microsoft.com/en-us/library/ms174937.aspx

Managing Multiple Instances of Analysis Services
https://msdn.microsoft.com/en-us/library/ms174906.aspx

 

Karan Gulati
SE, Microsoft Analysis Services

Comments

  • Anonymous
    September 23, 2009
    Hello Sir, thanks for these very interesting informations. I have an Analysis services Named Instance in a clustered environment with 2 NIC configured, and unfortunately, netstat states that AS only listens for incoming network connections on the first logical IP address. Is there something I can do ? Thank you Sir, Ludovic

  • Anonymous
    September 29, 2009
    Question: I have an Analysis services Named Instance in a clustered environment with 2 NIC configured, and unfortunately, netstat states that AS only listens for incoming network connections on the first logical IP address. Answer: Check other Nic Card might be used for Cluster HeartBeat. Regards Karan Gulati Microsoft SSAS Team

  • Anonymous
    September 30, 2009
    Thank you Karan, it turns out the other NIC is dedicated for client access only. I'll open a case with MS Support and we'll find the underlying reason. Have a great day, Ludovic