To assign a specific port number to the SQL Server Database Engine for remote access, take the following steps:
Open SQL Server Management Studio and log in to your database.
Right-click the server name in the left panel and choose Properties.
On the left side, navigate to the Connections page and make sure “Allow remote connections to this server” is enabled. Finally, close SQL Server Management Studio.
Launch SQL Server Configuration Manager and expand the SQL Server Network Configuration node. Select Protocols for your SQL Server instance and check that the TCP/IP protocol is enabled.
Right-click TCP/IP and choose Properties. In the TCP/IP Properties dialog box, select the IP Addresses tab and scroll down to the IPALL section. Make sure the TCP Dynamic Ports field is empty, and set the TCP Port to the desired port number.
Click Apply, then OK, to save your changes. Finally, restart your SQL Server to apply the changes.
You should now be able to connect to your SQL Server instance remotely through SQL Server Management Studio.
Note:
If you are experiencing problems with your remote connection, you may need to alter your Firewall settings. Make sure your firewall accepts communication on the given TCP port and does not block it.
For more assistance contact host.co.in support team