Shulou(Shulou.com)06/01 Report--

What this article shares with you is about how Holer can access the SQLServer database on the public network. The editor thinks it is very practical, so I share it with you for study. I hope you can get something after reading this article.

Public network accesses internal network SQLServer database

The SQLServer database is installed on the intranet host, which can only be accessed in the local area network. How can the local SQLServer database be accessed from the public network?

The specific steps for implementing using holer are described below.

1. Preparation 1.1 install and start the SQLServer database

The default installed SQLServer database port is 1433.

two。 Implement step 2.1 download and extract the holer package

Holer package: holer-xxx.tar.gz

Holer supports a variety of OS system platforms, please select the holer package that matches the local OS type.

2.2 get holer access key information

Apply for your own holer access key on the holer official website or use access key information publicly available in the open source community.

For example, the holer information you applied for is as follows. Here we take the holer information as an example:

-Holer Client: holerdemo@gmail.comAccess Key: 8866daebe02846t88s166733595fff5d-Internet Address: holer.org:65014Local Address: 127.0.0.1 -2.3 start the holer service

Windows system platform:

Open the CMD console and go to the directory where the executable is located to execute the command:

Holer-windows-xxx.exe-k 8866daebe02846t88s166733595fff5d

Linux or other system platforms:

Execute the command: nohup. / holer-xxx-xxx-k 8866daebe02846t88s166733595fff5d

2.4 access the mapped public network address

Enter on the database client

Hostname: holer.org port number: 65014

This allows you to access the local SQLServer database from the public network.

2.5 question consultation and help

When you encounter problems in the process of using holer, you can first check the log information printed by the holer console, so that it is easy to find out the specific cause of the problem.

The above is how Holer achieves external network access to SQLServer database. The editor believes that there are some knowledge points that we may see or use in our daily work. I hope you can learn more from this article. For more details, please follow the industry information channel.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.