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.
You may also try looking in this directory
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.
Using the Configuration Manager we can find what ID we need to look for.
Now open a command prompt. Start > Run > cmd
Now with the following commands we can use netstat to find what port SSAS is listening on.
Reviewing the output we find what we are looking for. The port is 2383.
Using the following commands we can output the information to a text file for whatever purposes you require.
And the output should look something like this.
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.