Wednesday, June 22, 2011

Microsoft SQL Server Analysis Services TCP port 2005 issues

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 tag and 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.