An easy way to access SQL Server databases in the intranet

Objective:

Sometimes we want to access the local area network SQL Server server, such as test environment database in the company intranet, back home or at the customer site to connect to the database in the intranet

The first step: if you can connect to the local area network database 192.168.150.129, remote also can connect it

The second step: Add a TCP port in the intranet pangolin, the IP of the local IP, port 1433, map to the external network port to fill

You can then use yxnat.softdev.top,7777 to access the SQL Server database in the intranet.

In the database connection configuration file, you can also connect yxnat by filling in the port number. softdev.top,3333

An easy way to access SQL Server databases in the intranet