Microsoft's SQL Server Management Studio will connect by default to port 1433 and there's nowhere in the connect dialog to specify a different port from the default. To connect using a different port specify the servername, a comma, and then the port number as shown in this post.
Sep 21, 2011 SQL SERVER - Find Port SQL Server is Listening - Port SQL Mar 15, 2014 How to Identify port number of SQL server - Stack Overflow Open SQL Server Management Studio; Connect to the database engine for which you need the port number; Run the below query against the database. select distinct local_net_address, local_tcp_port from sys.dm_exec_connections where local_net_address is not null. The above query shows the local IP as well as the listening Port number Solving Connectivity errors to SQL Server
Ports used for connections - Configuration Manager
Static Port: At the time of SQL server configuration, default instance of SQL Server listens on port 1433. This is called static or fixed port. The port can be changed for security purpose or client application requirement. Dynamic Port: The named instances (including SQL Server Express) are configured to listen on dynamic ports, by default. It
#3 – Configure SQL Server Configuration Manager. Launch the SQL Server Configuration Manager; Expand SQL Server Network Configuration; Select Protocols; Right click on the option “TCP/IP” and select “Properties” Click on the IP addresses tab; Scroll down to “IPAll” For TCP Port, put in 1433 #4 – Installing the CurrentWare Client
The default instance of SQL Server will listen on port 1433 (unless you’ve changed it to something else).However, by default, named instances will use a dynamic port, and SQL Server Browser will determine which port has been allocated and direct traffic accordingly.. This works well if you’re running multiple instances on your local machine, but is not so good in corporate and other T-SQL Script to check SQL Server Instance TCP/IP Port Dec 02, 2014 SQL Server cannot bind to the TCP/IP port on which SQL