If you want to assign a TCP/IP port number to the SQL Server Database Engine. You must follow the steps given below-
- Open SQL Server Management Studio and login to your database
- Now, right-click on the server name in the left panel and choose Properties
- Choose the Connections page on the left side and ensure that “Allow remote connections to this server” is checked. Now exit the SQL Server Management Studio
- Now open the SQL Server Configuration Manager and expand the node SQL Server Network Now Select Protocols for your SQL Server Instance. Ensure that the TCP/IP protocol enabled.
- Right-click on the TCP/IP and choose In the TCP/IP Properties dialog box, click on the IP Addresses tab and scroll down to the IPALL section. Make sure that the TCP Dynamic Ports is empty and TCP Port set to your desired TCP Port.
- Click the Apply button and then OK to save your changes. Once successfully done, restart your SQL Server
- Now you can still connect to your SQL Server Instance remotely with the help of SQL Server Management Studio.
Note:
If you still face a problem with your remote connection, it is most likely that you will have to configure your Firewall settings. Make sure that Firewall does not block your TCP Port.