What ports are your SQL Server services are running ?

You need to know which ports your SQL Server services are running.  This could be for Kerberos constrained delegation to Data Sources or to allow access through Firewalls.  Either way, the following guide explains how to go about this for your Analysis Services Service, and a similar process can be used to find ports for other SQL Server services.

For Analysis Services, you can see in Task Manager which port your MSMDSRV process is running.  Alternatively, open the SQL Server Configuration manager, select the Analysis Services service, select Properties, then on the Service tab, note the Process ID.

Now go to a command prompt and enter the following to dump the output to a file called netstatoutputfile.txt in the specified directory, in this case c:\tempfolder

netstat /ao -p TCP >> C:\tempfolder\netstatoutputfile.txt

Look for your process id and you will see port specified beside the IP address in the Local Address column.

A complete reference for the Analysis Services service specifically including firewall specific actions are outlined here http://msdn.microsoft.com/en-us/library/ms174937.aspx

Enjoy !

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 )

Google photo

You are commenting using your Google 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 )

Connecting to %s