SQL Server

Question

I hava instales mssqul in Ubuntu 22.04 an today update it from release 16.0.4085.2-1-preview to release 16.0.4095.4-1 but when try to start the serve I get this error:

× mssql-server.service - Microsoft SQL Server Database Engine
     Loaded: loaded (/lib/systemd/system/mssql-server.service; enabled; vendor preset: enabled)
     Active: failed (Result: exit-code) since Mon 2023-11-20 13:17:29 -05; 10s ago
       Docs: https://docs.microsoft.com/en-us/sql/linux
    Process: 2771 ExecStart=/opt/mssql/bin/sqlservr (code=exited, status=127)
   Main PID: 2771 (code=exited, status=127)
        CPU: 5ms

nov 20 13:17:29 server systemd[1]: mssql-server.service: Scheduled restart job, restart counter is at 3.
nov 20 13:17:29 server systemd[1]: Stopped Microsoft SQL Server Database Engine.
nov 20 13:17:29 server systemd[1]: mssql-server.service: Start request repeated too quickly.
nov 20 13:17:29 server systemd[1]: mssql-server.service: Failed with result 'exit-code'.
nov 20 13:17:29 server systemd[1]: Failed to start Microsoft SQL Server Database Engine.

Answer 1

Hi @Alejandro Warren,

The SQL Server Database Engine logs to the /var/opt/mssql/log/errorlog file in both the Linux and container installations. You need to be in superuser mode to browse this directory.

The installer logs here: /var/opt/mssql/setup-<time stamp representing time of install> You can browse the errorlog files with any UTF-16 compatible tool like vim or cat like this:

BashCopy

sudo cat errorlog

If you prefer, you can also convert the files to UTF-8 to read them with more or less with the following command:

BashCopy

sudo iconv -f UTF-16LE -t UTF-8 <errorlog> -o <output errorlog file>

Please check the error log so that we could get more details.

https://learn.microsoft.com/en-us/sql/linux/sql-server-linux-troubleshooting-guide?view=sql-server-ver16

Regards，

Zoe Hui

---

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