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) (edited on 2024-08-19 04:24 (UTC) by doctorzeus)
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.
If you have a problem compiling libldapV2.4, go and ask on that package page, not here.
You can get libldap V2.4 here from this AUR package:
https://aur.archlinux.org/packages/libldap24