What TCP port SQL Server Analysis Services 2005 uses
User Rating: / 10
PoorBest 
Written by Vidas Matelis   
Saturday, 14 April 2007 09:36

Q: What TCP port Microsoft SQL Server Analysis Services 2005 uses?

A: Default instance of Analysis Services uses TCP port 2383. Named SSAS instances use dynamic ports. You can specify port that you want SSAS to listen in Analysis Services property "Port". If property "Port" is not specified (0), then port is picked dynamically. You can check dynamically assigned port in msmdredir.ini file located in %Program files%\Microsoft SQL Server\90\Shared\ASConfig. Find <Instances> tag and <Port> tag for instance you are interested in. Example

<Instances>
 <Instance>
  <Name>TestInstance1</Name>
  <Port>12345</Port>
 </Instance>
</Instances>

If you are using SQL Browser service, it uses port 2382.

< Prev   Next >
 
Comments (2)
2 Monday, 28 March 2011 02:58
SILVERSOV
At the command prompt:

netstat -n -b

Look for the Analysis Services process (msmdsrv.exe). It should list the IP address and listening port details.
1 Monday, 01 March 2010 22:13
RICKGAO
To check SSAS port number for SQL Server 2005. You can go to management studio and connect to the SSAS instance, then right click the server and click the properties. On the second line from the bottom you will find the port number there.

 

Data Warehouse Explorer