SQL Server fails after upgrading to Ubuntu 24.04

Isaac Abodunrin 0 Reputation points
2024-10-03T23:55:57.2+00:00

I recently upgraded from Ubuntu 22 to 24.04. This seems to have broken my sql server. I get the following error when I run sudo systemctl status mssql-server:

sudo systemctl status mssql-server
× mssql-server.service - Microsoft SQL Server Database Engine
     Loaded: loaded (/usr/lib/systemd/system/mssql-server.service; enabled; preset: enabled)
     Active: failed (Result: exit-code) since Fri 2024-10-04 01:46:22 SAST; 6s ago
   Duration: 3ms
       Docs: https://docs.microsoft.com/en-us/sql/linux
    Process: 52930 ExecStart=/opt/mssql/bin/sqlservr (code=exited, status=127)
   Main PID: 52930 (code=exited, status=127)
        CPU: 2ms

Oct 04 01:46:22 Dell systemd[1]: mssql-server.service: Scheduled restart job, restart counter is at 3.
Oct 04 01:46:22 Dell systemd[1]: mssql-server.service: Start request repeated too quickly.
Oct 04 01:46:22 Dell systemd[1]: mssql-server.service: Failed with result 'exit-code'.
Oct 04 01:46:22 Dell systemd[1]: Failed to start mssql-server.service - Microsoft SQL Server Database Engine.

SQL Server Other
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Olaf Helper 47,436 Reputation points
    2024-10-04T05:05:39.2066667+00:00

    I recently upgraded from Ubuntu 22 to 24.04.

    As far as I know, Unbuntu version 24 isn't supported by SQL Server, only 22, see

    https://learn.microsoft.com/en-us/sql/linux/quickstart-install-connect-ubuntu?view=sql-server-ver16&tabs=ubuntu2004

    0 comments No comments

  2. ZoeHui-MSFT 41,491 Reputation points
    2024-10-07T05:59:55.53+00:00

    Hi @Isaac Abodunrin,

    SQL Server is not support on Ubuntu Server 24.04.

    Currently only Ubuntu 20.04 or 22.04 is supported as said in the official documentation.

    You could install it as a docker container.

    Regards,

    Zoe Hui


    If the answer is helpful, please click "Accept Answer" and upvote it.

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.