SSAS port for named instance

 

Here is what I have learnt today while configuring the firewall to allow remote access to a named instance of SSAS.

You have to allow access through the firewall over port 2382. Subsequently you have to allow access over the specific port used by your named instance of Analysis Services.

But how can you determine on which port SSAS is running?

For that you have to open a command prompt and type in the following:

netstat /ao >>c:\output.txt

In the SQL Server Configuration Manager you have to look up the Process ID of your named instance of SSAS (for example: PID=2236).

Then you have to look for the PID in the output file and find the corresponding TCP IP:port information.

Once you know the port used by your named instance of SSAS, you have to make an inbound rule in the firewall to allow remote access to your named instance of SSAS.

Information about the SSAS ports can be found here. Also see my previous post about the firewall settings.

More information about these ports can also be found in “SQL Server 2008 Books Online” – “Configuring the Windows Firewall to Allow SQL Server Access”.

Ports used by Analysis Services

SQL Server installation and Firewall Settings

 

After installation of a SQL Server instance we need to make some changes to the firewall settings to make the SQL Server Database Engine externally accessible.

The following inbound rules should be made in the Windows Firewall:

• Port 1433, Protocol TCP (Database Engine default instance)
• Port 1434, Protocol UDP (SQL Server Brower service for a Database Engine named instance)

Now we should be able to connect to the SQL Server Database Engine.

To make the Analysis Services externally accessible, you need to open the following ports:

• Port 2382, Protocol TCP (SQL Server Browser service for an Analysis Services named instance)
• Port 2383, Protocol TCP (Analysis Services default instance)

More information about these ports can be found in “SQL Server 2008 Books Online” – “Configuring the Windows Firewall to Allow SQL Server Access”.

Ports used by the Database Engine

Ports used by Analysis Services