How to find out what port Analysis Services is running on?

_{Tuesday, May 11, 2010 1:41 PM}

Hi I need to find out what port an instance os SSAS is running on. Anyone know how to do this?

_{Tuesday, May 11, 2010 5:30 PM ✅Answered}

Hi,

You can findout the ports on which your SSAS server is listening using "netstat" command.

Follow the below mentioned steps to run the command:

1. Open Task manager and get the PID for msmdsrv.exe (this is the SSAS application exe).
2. Open command prompt and type netstat /ao >> <File path>\File name>.txt . E.g.: you want to save the ports output to PortOutput.txt then the command would be netstat /ao >> c:\PortOutput.txt.
3. Look for the PID in output file, you can find the corresponding TCP IP port on which the server is listening.

Hope this helps.

Regards,

Ranjith

_{Thursday, May 13, 2010 3:09 AM ✅Answered}

In addition to, in SSAS, there are several server properties related to Port:

http://msdn.microsoft.com/en-us/library/cc966526.aspx

For example:

Port

Port is a server property that controls which port a SSAS instance listens on. The default instance listens on port 2383, while named instances are dynamically allocated. This behavior can be changed by explicitly assigning a port to either the default or named instance of SSAS. If the value for Port is 0, the default behavior described above is achieved. Otherwise, the value is treated as an absolute (static) port number to use for the specified instance. For a discussion about ports, see the “Instances” section of this paper.

Hope this helps,

Raymond

_{Tuesday, May 11, 2010 4:18 PM}

For 2005 instance:

Use SSMS to connect to the SSAS instance

Right click the server and click Properties. You should see the port number.

-Remember to mark as helpful/the answer if you agree with the post.

_{Friday, May 14, 2010 10:02 AM}

hi,

Sorry im late getting back on this. 

bimossuser  - I cant connect in SSMS without the port number for some reason. Im not sure what it is about our environment but to connect through SSMS you need to specify the port number i.e    DatabaseInstanceName:10652

Ranjith   - I cant see a PID next to msmdsrv.exe in the task Manager. When I

run          **  netstat /ao >> c:\PortOutput.txt       **

it appears to run, but creates no file.

Thanks for your help as ever,

Zoe

_{Friday, May 14, 2010 10:12 AM}

Hi Zoe,

Can you please verify if the user account (using which you run the netstat command) has the write permissions on the directory path specified?

Regards,

Ranjith

_{Friday, May 14, 2010 10:28 AM}

Hi Ranjith,

Yes It does

cheers