Failed Start for Microsoft SQL Server Database Engine on Linux

chetan picture chetan · Feb 2, 2018 · Viewed 9.4k times · Source

I have installed mssql on Ubuntu 16.04. following are the details of sql server. ms sql (14.0.3015.40-1) i.e SQL server 2017.

when I run the configuration command #sudo /opt/mssql/bin/sqlservr-setup I got error sudo: /opt/mssql/bin/sqlservr-setup: command not found

I have stopped and restarted but of no use.

When I check the status by command #systemctl status mssql-server

I got

mssql-server.service - Microsoft SQL Server Database Engine
   Loaded: loaded (/lib/systemd/system/mssql-server.service; enabled; vendor preset: enabled)
   Active: inactive (dead) (Result: exit-code) since Fri 2018-02-02 16:15:29 IST; 4min 20s ago
     Docs: https://docs.microsoft.com/en-us/sql/linux
  Process: 28050 ExecStart=/opt/mssql/bin/sqlservr (code=exited, status=200/CHDIR)
 Main PID: 28050 (code=exited, status=200/CHDIR)

Feb 02 16:15:28 chetan-desktop systemd[1]: mssql-server.service: Unit entered failed state.
Feb 02 16:15:28 chetan-desktop systemd[1]: mssql-server.service: Failed with result 'exit-code'.
Feb 02 16:15:29 chetan-desktop systemd[1]: mssql-server.service: Service hold-off time over, scheduling restart.
Feb 02 16:15:29 chetan-desktop systemd[1]: Stopped Microsoft SQL Server Database Engine.
Feb 02 16:15:29 chetan-desktop systemd[1]: mssql-server.service: Start request repeated too quickly.
Feb 02 16:15:29 chetan-desktop systemd[1]: Failed to start Microsoft SQL Server Database Engine.

I have googled and tried all possible options. But unable to start SQL server.

Please guide me through this.

Answer

Panagiotis Kanavos picture Panagiotis Kanavos · Feb 2, 2018

The error says that the executable wasn't found in this path, not that the service couldn't start.

According to the installation instructions for Ubuntu you need to run mssql-conf setup to configure the server :

sudo /opt/mssql/bin/mssql-conf setup

not sqlservr-setup