Time ago I installed mssql-server on my debian VPS and works fine. Now, mssql-server not run and I don't know what is changed.

If type /opt/mssql/bin/sqlserver I get

2019-07-07 18:13:19.79 Logon       Error: 18456, Severity: 14, State: 7.
2019-07-07 18:13:19.79 Logon       Login failed for user 'sa'. Reason: An error occurred while evaluating the password. [CLIENT:]

If I start service sudo systemctl start mssql-server I get

jul 07 18:27:23 vps495056 systemd[1]: Started Microsoft SQL Server Database Engine.
-- Subject: Unit mssql-server.service has finished start-up
-- Defined-By: systemd
-- Support: https://www.debian.org/support
-- Unit mssql-server.service has finished starting up.
-- The start-up result is done.
jul 07 18:27:23 vps495056 sqlservr[28229]: /opt/mssql/bin/sqlservr Error: Directory [/var/opt/system/] could not be created.  Errno [13]
jul 07 18:27:23 vps495056 systemd[1]: mssql-server.service: Main process exited, code=exited, status=1/FAILURE

I created var/opt/system directory because it not exist.

drwxr-sr-x  2 mssql    mssql     4096 jul  5 18:46 system

The mssql config file

# cat /var/opt/mssql/mssql.conf 
accepteula = Y

lcid = 1033

I tried reinstalled mssql-server but no luck. I get same errors after that.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.