How to check the port number of Microsoft SQL Server Analysis Services
Article ID: KB0078530
Updated On:
| Products | Versions |
|---|---|
| Spotfire Connector for Microsoft SQL Server Analysis Services | All Versions |
Description
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.
Issue/Introduction
How to check the port number of Microsoft SQL Server Analysis Services
Environment
All Supported Operating Systems
Resolution
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
- 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
Additional Information
Feedback
Yes
No
Powered by
