HiveBrain v1.2.0
Get Started
← Back to all entries
snippetsqlMinor

How do I reset the SQL Server password on Linux?

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
thesqlpasswordlinuxhowserverreset

Problem

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?

Solution

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

Code Snippets

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

Context

StackExchange Database Administrators Q#192887, answer score: 3

Revisions (0)

No revisions yet.