Making SQL Server Accessible Over Internet
We can Make the SQL Server Accessible over Internet by following steps:
2. Open SSMS, right click on server > properties and check SQL Server and Windows Authentication mode
4. Go to Server property and check “allow remote connections to this server”
5. Go to SQL server configuration manager > SQL server network configuration > Protocols for SQL and make sure TCP/IP is enabled
6. Click on TCP/IP and enter port number in IPAll section
8. In next steps we will enable port forwarding (i.e. It will redirect request received on public IP and port to another IP and port combination)
In mapped IP we can mention static IP of system also (i.e. 192.168.1.30)
9. Now from other system outside of current network, access the SQL server and enter server details and credentials. Enter server name eg 113.143.120.100, 4729\SQL
Hope above Helps!