Extranet access the Intranet SQLServer database

An SQLServer database is installed on an Intranet host and can be accessed only on a LAN. How can I access the local SQLServer database from a public network?

This article walks you through the steps to implement using Holer.

1. Preparation

1.1 installing and starting the SQLServer database

The default SQLServer database port is 1433.

2. Implementation steps

2.1 Download and Decompress the Holer Software package

Holer software package: holer-XXX.tar. gz

Holer supports various OS platforms. Select the Holer software package that matches the local OS type.

2.2 Obtaining Holer Access Key Information

Apply for an exclusive Holer Access Key on the Holer website or use access Key information available on the open source community.

For example, the Holer information obtained in the application is as follows:

--------------------------------------------- Holer Client : [email protected] Access Key : 8866daebe02846t88s166733595fff5d --------------------------------------------- Internet Address : Holer.org: 65014 Local Address: 127.0.0.1:1433 -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --Copy the code

2.3 Starting the Holer Service

Windows system Platform:

Open CMD console, enter the directory where the executable program resides and run the following command:

holer-windows-xxx.exe -k 8866daebe02846t88s166733595fff5d

Linux or other system platforms:

Execute the command: nohup. / holer – XXX – XXX – 8866 daebe02846t88s166733595fff5d k

2.4 Accessing mapped Public IP Addresses

Enter on the database client

Host name: Holer.org Port number: 65014

In this way, you can access the local SQLServer database from the public network.

2.5 Problem consultation and help

If a problem occurs during the use of holer, you can view the log information printed on the Holer console first. In this way, you can easily locate the specific cause of the problem.

For more examples of how to use Holer, refer to the technical documentation related to Holer.