How to access SQL server from public network
In order to access SQL server from public network, there are couple of things that you need to do in addition to following this article by Microsoft. Following the articles from Microsoft, you will have set up your SQL server instance to support TCP protocol and configured a fixed port. You will also have this port added to the inbound rules in windows firewall so that incoming traffic can be allowed on this port. However, you may still not be able to access your SQL server from public network although it is accessible on your LAN. …