What port is a remote SQL Server 2005 running on?

Question

How do I find what port is my remote SQL Server 2005 running on?

Answer 1

Unless it's modified, it's the default port 1433.

Answer 2

SQL Server's default port is 1433. If you are unable to connect, you may have to make sure your firewall settings are correct.

Alternatively you can find out which port SQL Server is running by opening your command prompt: (Start > Run > CMD). Type "netstat" and hit enter, this will show you what you're looking for.

You could also check SQL Server's Error Log on the remote server to determine the port. Here are some more intracate ways of determining the port.

Additional information about ports right here on SO.