How do I configure SQL Server to listen on port 1433?

Question

Steps Change the port in the SQL Server Configuration Manager, and under the TCP/IP which has the layer of the IP v4 , v6 etc, and change the port accordingly. Then, the port number is only changed on the TCP port level at the SQL configuration. Change the page name, login.

How do I get SQL Server to listen on port 1433?

Solution1Run the SQL Server Configuration Manager.2Select the SQL Server Network Configuration.3Select from the list the instance you want to configure to listen to on a specific port.4To change the port assignment right-click on the TCP/IP protocol and select Properties.5Click on the IP Addresses tab.

How do I specify a port when connecting to SQL Server?

Normally you would just type the server name into field but to specify a different port use a comma then the port number. Then specify the login credentials, click the connect button, and assuming everything is correct it should then connect to the SQL Server.

How do you specify a port to listen on?

The general rules of thumb for choosing a port include choosing at least a 4 digit number and avoid anything below 1024. Also, even if the port was already in use by another service, you could re-assign it to listen to another port, its your network after all.

What port is SQL Server listening on?

By default SQL Server listens on TCP port number 1433, but for named instances the TCP port is dynamically configured.

Expert · Answer