How to enable remote MsSql Port

To enable remote MsSql port, RDP to your server.

Go to start >> programs and search for sql configuration manager.

Open it >> Go to Sql server network configuration >> Click on your Sql server name >> TCP IP >> Click on Ip Addresses Tab >> Locate your IP and type the desire port in “TCP PORT”, default port is 1433.  Click apply and OK.

It will ask you for service restart >> Go to Sql services section >> look for the running sql server service >> right click on it and restart it.
Also make sure that you open port 1433 in firewall. Without it port wont work from remote.