Select the product you need help with

How to determine and change the port of an SSAS Instance

Article ID: 2466860 - View products that this article applies to.

SUMMARY

This article discusses the procedure to find the port an instance of Analysis services is currently running on and the procedure to change the port when required.

Back to the top | Give Feedback

MORE INFORMATION

How to determine the port SSAS is running: You can use one of the following two procedures to determine the port a SQL Server Analysis Service (SSAS) instance is listening on:

Procedure 1:

Open Task Manager and get the Process Id (PID) for msmdsrv.exe.
Open command Prompt type netstat /abo >>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 (For example:192.168.1.1:5585)

Procedure 2:

Another way to get the port number for a SSAS instance is to look at the following file:

%ProgramFiles%\Microsoft SQL Server\90\Shared\ASConfig\msmdredir.ini

This file will have information about all the named instances and the current port each of them is listening on. The file will have entries that are similar to the following:

<Instances>
<Instance>
<Name>SQL2008R2</Name>
<Port>62037</Port>
</Instance>
</Instances>

Note: The SQL Server Browser service records the port number on which each named instance is running on the computer in the Msmdredir.ini file (it records this the first time a user attempts to connect to the named instance, not when the named instance starts) and uses this information to direct client requests to connect to the named instance to the appropriate TCP port. To work properly, the SQL Server Browser service must run under a security account that has local administrator rights, such as the local system account. If a named instance is installed, the SQL Server Browser service is, by default, configured to start automatically.

For additional information you can refer to the following topic on Microsoft TechNet:
SQL Server 2005 Analysis Services (SSAS) Server Properties

(http://technet.microsoft.com/en-us/library/cc966526.aspx)

How to change Port for SSAS Service (SSAS 2005 & SSAS 2008):

Non-clustered environment (Default Instance or Named Instance)

You can configure a named instance to run under a specified port by changing the Port property for the Analysis Services instance to a specified value by using SQL Server Management Studio (this is an advanced property) or by editing the Port server property (<Port>0</Port>) in Msmdsrv.ini file directly (in the ../OLAP/Config folder). A value of zero (the default value) means that Analysis Services dynamically assigns the port at startup

Note: To ensure that the new port information for the instance is relayed by the SQL Browser services to the client applications that are connecting to this instance ensure that the InstanceVisible property for the instance is set to 1. Otherwise you may experience connectivity issues from your client applications.

Clustered environment (Default Instance or Named Instance)

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

Back to the top | Give Feedback

REFERENCES

Resolving Common Connectivity Issues in SQL Server 2005 Analysis Services Connectivity Scenarios
(http://technet.microsoft.com/en-us/library/cc917670.aspx)
2429685
(http://support.microsoft.com/kb/2429685)
Cannot connect to a named instance of a clustered analysis services
How to: Configure Windows Firewall for Analysis Services Access
(http://msdn.microsoft.com/en-us/library/ms174937.aspx)
Managing Multiple Instances of Analysis Services
(http://msdn.microsoft.com/en-us/library/ms174906.aspx)

Back to the top | Give Feedback

Note This is a "FAST PUBLISH" article created directly from within the Microsoft support organization. The information contained herein is provided as-is in response to emerging issues. As a result of the speed in making it available, the materials may include typographical errors and may be revised at any time without notice. See Terms of Use

(http://go.microsoft.com/fwlink/?LinkId=151500)

for other considerations.

Back to the top | Give Feedback