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

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 2

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