mssql-docker
mssql-docker copied to clipboard
configure_db.sh SA_PASSWORD should be MSSQL_SA_PASSWORD
SA_PASSWORD should be MSSQL_SA_PASSWORD
DBSTATUS=$(/opt/mssql-tools/bin/sqlcmd -h -1 -t 1 -U sa -P $SA_PASSWORD -Q "SET NOCOUNT ON; Select SUM(state) from sys.databases")
For others who run into this issue, the error that you see is:
Sqlcmd: 'SET NOCOUNT ON; Select SUM(state) from sys.databases': Unknown Option. Enter '-?' for help.
The solution, is simply to replace SA_PASSWORD in the .sh file with MSSQL_SA_PASSWORD.