search

microsoft / mssql-docker

Official Microsoft repository for SQL Server in Docker resources
MIT License
1.71k stars 754 forks source link

configure_db.sh SA_PASSWORD should be MSSQL_SA_PASSWORD #842

Open robert-s-lee opened 1 year ago

robert-s-lee commented 1 year ago

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")
tlunsfordCXP commented 1 month ago

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.