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

Operating system version: ubuntu16.04

Database version: SQLserver 2017

Due to the need of the company's business to temporarily map the internal network database to the public network through the router port, in a short period of one hour, the password of the SA was changed by an unknown organization, resulting in an abnormal accident.

When an exception is found, the database is removed from the public network as soon as possible, and the SA password is attempted to recover. Baidu many places are mostly windows systems through local login to change the sa password, can not find the linux system to reset the SA password method, and finally think of the installation of the database when there is a step to set the SA password, check the installation documents, done.

Now list the operation steps, in fact, just one step, hoping to help those of you who encounter the same problem

Ubuntu@ubuntu:~$ sudo / opt/mssql/bin/mssql-conf setup

Select the installed version and enter the password for sa.

After performing the above operation, check the database and find that the data is not abnormal, it should be found in time and the database will be removed from the external network as soon as possible. * personnel have not yet had time to do anything else. But he also broke out in a cold sweat.

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.