Hey, I have installed MSSQL. When I am trying to run the server with systemctl, it gives an error:
× mssql-server.service - Microsoft SQL Server Database Engine
Loaded: loaded (/usr/lib/systemd/system/mssql-server.service; enabled; preset: disabled
)
Active: failed (Result: exit-code) since Wed 2024-05-15 09:14:59 CEST; 3s ago
Duration: 2.793s
Docs: https://docs.microsoft.com/en-us/sql/linux
Process: 8606 ExecStart=/opt/mssql/bin/sqlservr (code=exited, status=18)
Main PID: 8606 (code=exited, status=18)
CPU: 3.775s
May 15 09:14:59 archlinux systemd[1]: mssql-server.service: Scheduled restart job, restart counter is at 3.
May 15 09:14:59 archlinux systemd[1]: mssql-server.service: Start request repeated too quickly.
May 15 09:14:59 archlinux systemd[1]: mssql-server.service: Failed with result 'exit-code'.
May 15 09:14:59 archlinux systemd[1]: Failed to start Microsoft SQL Server Database Engine.
May 15 09:14:59 archlinux systemd[1]: mssql-server.service: Consumed 3.775s CPU time, 664.6M memory peak, 0B memory swap peak.
Pinned Comments
doctorzeus commented on 2023-05-16 10:15 (UTC) (edited on 2023-06-17 03:56 (UTC) by doctorzeus)
This current package is MSSQLServer2022.
For anyone who needs to set the compatibility level of a db to migrate to an older version, see this article:
https://learn.microsoft.com/en-us/sql/t-sql/statements/alter-database-transact-sql-compatibility-level?view=sql-server-ver16
doctorzeus commented on 2023-02-22 22:23 (UTC)
NOTES ON libldap 2.4:
Yes there is a newer version in the official repos but the binaries do not run without this version which is listed in the dependencies by Microsoft.
You can get libldap V2.4 here from this AUR package:
https://aur.archlinux.org/packages/libldap24