Sqlcmd: Error: Microsoft ODBC Driver 17 for SQL Server : Login failed for user 'SA'

c# sql-server entity-framework docker asp.net-core

Try adding '(quotation mark) around your username and password : 'sa' 'Pass@word'

"ConnectionStrings": {"DefaultConnection": "Server=sql.data,1433;MultipleActiveResultSets=true;User Id='SA';Password='Pass@word'"

c# sql-server entity-framework docker asp.net-core

Replace Password with SA_Password in connection string:

  "ConnectionStrings": {    "DefaultConnection": "Server=sql.data,1433;MultipleActiveResultSets=true;User Id=SA;SA_Password=Pass@word"  },

CodeHunter