snippetsqlMinor
How do I reset the SQL Server password on Linux?
Viewed 0 times
thesqlpasswordlinuxhowserverreset
Problem
The instructions on technet say that I either have to reset the SQL Server configuration with
What the simplest way to way to reset the password on Linux?
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?
Solution
While not mentioned on technet, there is an argument to
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
Also, while you're there you may as well use
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
mssql-conf that works here,sudo /opt/mssql/bin/mssql-conf set-sa-passwordYou'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 spywareI'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
Code Snippets
sudo /opt/mssql/bin/mssql-conf set-sa-passwordContext
StackExchange Database Administrators Q#192887, answer score: 3
Revisions (0)
No revisions yet.