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?
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.Sign up to join this community
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.
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
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'