Take the 2-minute tour ×

I need to know the default port settings for the following services

  1. SQL Server
  2. SQL Browser
  3. SQL Reporting services
  4. SQL Analysis services

I neeed to know the port settings for these services for different versions of SQL Server (2000,2005,2008)

Also let me know whether the default port setting will change based on sql server versions

Thanks in advance.

share|improve this question
Is this a Jeopardy clue or some kind of demand? I would suggest rewording to keep with the question and answer format. –  spoulson Sep 30 '08 at 12:52
Is there a category for "really, you should google it". Googling "sql server port" got me this, as the top link: support.microsoft.com/kb/287932. "INF: TCP Ports Needed for Communication to SQL Server Through a Firewall". But points (literally) for asking. –  Nic Wise Sep 30 '08 at 13:04
add comment

6 Answers

up vote 75 down vote accepted
  1. The default SQL Server port is 1433 but only if it's a default install. Named instances get a random port number.

  2. The browser service runs on port UDP 1434.

  3. Reporting services is a web service - so it's port 80, or 443 if it's SSL enabled.

  4. Analysis services is 2382 but only if it's a default install. Named instances get a random port number.

share|improve this answer
add comment

If you have access to the server then you can use

select local_tcp_port from sys.dm_exec_connections where local_tcp_port is not null

For full details see port number of SQL Server

share|improve this answer
add comment

The default, unnamed instance always gets port 1433 for TCP. UDP port 1434 is used by the SQL Browser service to allow named instances to be located. In SQL Server 2000 the first instance to be started took this role.

Non-default instances get their own dynamically-allocated port, by default. If necessary, for example to configure a firewall, you can set them explicitly. If you don't want to enable or allow access to SQL Browser, you have to either include the instance's port number in the connection string, or set it up with the Alias tab in cliconfg (SQL Server Client Network Utility) on each client machine.

For more information see SQL Server Browser Service on MSDN.

share|improve this answer
add comment


the default port hasn't changed yet

share|improve this answer
add comment

You can use SQL Configuration Manager to set individual IP addresses to use dynamic ports or not (value of 0 = yes, use dynamic port), and to set the TCP port used for each IP.

But be careful: I recommend first mapping out your instances, IPs, and ports, and planning such that no instances or IPs step on each other before starting to make changes willy-nilly.

share|improve this answer
add comment

We can take a look at three different ways you can identify the port used by an instance of SQL Server.

  1. Reading SQL Server Error Logs
  2. Using SQL Server Configuration Manager
  3. Using Windows Application Event Viewer

    USE master

    xp_readerrorlog 0, 1, N'Server is listening on', 'any', NULL, NULL, N'asc'

Identify Port used by SQL Server Database Engine Using SQL Server Configuration Manager


  2. In SQL Server Configuration Manager, expand SQL Server Network Configuration and then select Protocols for on the left panel. To identify the TCP/IP Port used by the SQL Server Instance, right click onTCP/IP and select Properties from the drop down as shown below.

For More Help

share|improve this answer
add comment

Your Answer


