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: 127.0.0.1]
If I start service sudo systemctl start mssql-server I get
jul 07 18:27:23 vps495056 systemd: 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: /opt/mssql/bin/sqlservr Error: Directory [/var/opt/system/] could not be created. Errno
jul 07 18:27:23 vps495056 systemd: 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
[EULA]
accepteula = Y
[language]
lcid = 1033
I tried reinstalled mssql-server but no luck. I get same errors after that.
Asked by crossmax
(199 rep)
Jul 7, 2019, 04:34 PM
Last activity: Jan 6, 2021, 03:02 PM
Last activity: Jan 6, 2021, 03:02 PM