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

How can I tell if port 1433 is working for SQL Server?

Check SQL Server configuration manager to see if it's a specific port, or dynamic ports. If it's using dynamic ports, then as long as you don't have multiple instances on the server, netstat -abn is probably the simplest way to find what it's using.

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 I test my port 1433 connection?

You can check TCP/IP connectivity to SQL Server by using telnet. For example, at the command prompt, type telnet 192.168. 0.0 1433 where 192.168. 0.0 is the address of the computer that is running SQL Server and 1433 is the port it is listening on.

How do I change the port that SQL Server is listening on?

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.