Default port for SQL Server

Question

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.

Answer 1

1433

the default port hasn't changed yet

Answer 2

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.

Answer 3

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.

Answer 4

how can i change the default port for sql server 2005 reporting services.

Answer 5

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.