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.
You must be logged in to post a comment.