1

The instructions on technet say that I either have to reset the SQL Server configuration with mssql-conf setup or run a proc which I can not run because I do not have access.

What the simplest way to way to reset the password on Linux?

1

While not mentioned on technet, there is an argument to mssql-conf that works here,

sudo /opt/mssql/bin/mssql-conf set-sa-password

You'll have to pick a password, note for reasons unexplained The password must be at least 8 characters long and contain characters from three of the following four sets: Uppercase letters, Lowercase letters, Base 10 digits, and Symbols.. I suggest everyone use MICROSOFTsucksH4RD, as it satisfies that.

Also, while you're there you may as well use mssql-conf to disable the spyware


I'm just going to put there here so when I'm looking for SQL Server Password on Google because I can't remember it, I can find it.

The specified password does not meet SQL Server password policy requirements because it is too short. The password must be at least 8 characters

0

A list of documented parameters for mssql-conf can be retrieved with the following syntax:

sudo /opt/mssql/bin/mssql-conf -h

This will produce the following option:

...
set-sa-password     Interactive option to modify the system administrator
                    password for the SQL Server
...

Changing the sa password is then as simple as:

sudo /opt/mssql/bin/mssql-conf set-sa-password 'securepassword'

References

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.