I want to access my POS over the Internet from Laptop. How to connect to a remote SQL Server?
With remote SQL Server that allows you to access your POS over the Internet.
Step 1: Get IP Address on ServerExample: 192.168.1.60
Notes: This server is assigned a static IP address, the address does not change. Use dynamic IP addresses, which are assigned by the network when they connect and change over time.
Step 2: Get SQL Server PortExample: 50640 or 49302
Step 3: Port Forwarding - How to Remote Access your SQL ServerNotes:
- About SQL Server Port Forwarding: the same as IP Camera Port Forwarding. You type your SQL Server IP Address and SQL Server Port.
- Search on YouTube with keywords: Port Forwarding for [Your Modem Name - Cisco, Linksys, TP-Link...].
Step 4: Get your public IP AddressNotes: This IP address is dynamic IP address. It changed over time.
Step 5: Use Dynamic DNSEvery 15 minutes, I want to update this public IP Address to my domain. Please Setup Dynamic DNS on your modem or Install Dynamic DNS Update Clients on your server.
You can use Dyn or No-IP Service.
Step 6: On Laptop, Setup Multiple Database ServerYou go to the following folder:
[Public IP Address]\IPTPOS, [SQLServer Port]
[Domain Name]\IPTPOS, [SQLServer Port]
Notes: Right Click file IPTPOS.MultiDatabaseServer.exe and Select Send to => Desktop (create shortcut). Then you can quickly run this file from Desktop screen.