How to check the port number of Microsoft SQL Server Analysis Services

Date Posted: 2019-05-03
Product: TIBCO Spotfire®

Problem:

Solution:

Microsoft SQL Server Analysis services (SSAS) listens on port 2383 by default. If a Spotfire Analyst, using the TIBCO Spotfire Connector for Microsoft SQL Server Analysis Services, cannot connect to SSAS on port 2383, it might be because SSAS is listening on another port.
If you have the SQL Server Management Studio installed and have access to the SSAS server, then you can follow the below steps to find the listening port of Analysis Services.

- Open SQL Server management Studio and connect to Analysis services
- Right click the server instance and choose properties
- Click General from the left hand side menu
- Find "Port" in the list on the right hand side.
- If the port number is 0 then SSAS is listening on 2383 otherwise the port number will be shown here.

For other methods, refer to the below article: http://https://docs.microsoft.com/en-us/sql/analysis-services/instances/configure-the-windows-firewall-to-allow-analysis-services-access?view=sql-server-2017

https://support.microsoft.com/en-in/help/2466860/how-to-determine-and-change-the-port-of-an-ssas-instance https://docs.microsoft.com/en-us/sql/analysis-services/instances/configure-the-windows-firewall-to-allow-analysis-services-access?view=sql-server-2017

https://support.microsoft.com/en-in/help/2466860/how-to-determine-and-change-the-port-of-an-ssas-instance