Finding SQL Server Analysis Services listening port

I have not worked with SQL Server Analysis Server very much. That is apparently changing as of now and I am still undecided on how I feel about that. Don’t get me wrong. I really enjoy working in SQL and will keep an open mind as my learning path continues. My heart however is with the main SQL engine.

During the server setup and configuration we record basic information on the server. One of the pieces of information I needed was what port Analysis Server listens on. I had no idea. So how do we determine what port?

Search for ASConfiguration

There is a chance you may find SSAS configuration by searching for msmdredir.ini.

search

You may also try looking in this directory

emptyfolder

If you can’t find the ini file anywhere you may find it via the Process ID and netstat.

Finding Process ID

We need to start with finding the process ID that SSAS is using.

configmanager

Using the Configuration Manager we can find what ID we need to look for.

Now open a command prompt. Start > Run > cmd

open_cmd

Now with the following commands we can use netstat to find what port SSAS is listening on.

netstat_host

Reviewing the output we find what we are looking for. The port is 2383.

netstat_host_result

Using the following commands we can output the information to a text file for whatever purposes you require.

netstat_output

And the output should look something like this.

netstat_output_result

Conclusion

As we can see, there are a few different ways to track down what port SSAS is listening on. The default port for SSAS is 2383. As most of you know, the port this component listens on can be changed. The evidence in the screen shot confirms that. Knowing how to find the information you seek as it relates to SQL Server and it components is an important part of a DBAs job.

Cheers!

About these ads

One comment

  1. Hi, thanks for posting this.
    One correction, the sentence “Reviewing the output we find what we are looking for. The port is 4132.” needs to be changed to “Reviewing the output we find what we are looking for. The port is 2383.” as 4132 is the PID.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s