question

RameshChandraRC-8663 avatar image
0 Votes"
RameshChandraRC-8663 asked ·

sudo systemctl start mssql-server -- on WSL2 Ubuntu

$ sudo systemctl start mssql-server System has not been booted with systemd as init system (PID 1). Can't operate. I installed mssql server by following https://docs.microsoft.com/en-us/sql/linux/quickstart-install-connect-ubuntu?view=sql-server-ver15 on WSL2 on Windows 10 pro. Can someone help me resolve this issue.

sql-server-general
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Cathyji-msft avatar image
0 Votes"
Cathyji-msft answered ·

Hi @RameshChandraRC-8663,

Quote from the blog Dealing with SQL Server on Linux on WSL2,

I would say you can use your new fresh installed SQL Server instance, but it requires to manually start / stop it because there are no systemctl commands to handle it. A good alternative could be to rely on init scripts and start-stop-daemon wrapped into LSB-compliant init scripts.

Suggest you read the blog to get the detail steps to resolve the issue.


If the response is helpful, please click "Accept Answer" and upvote it, thank you.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


·
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

RameshChandraRC-8663 avatar image
0 Votes"
RameshChandraRC-8663 answered ·

Thank you for the response - I removed mssql packages. I re installed a fresh copy. By following https://blog.developpez.com/mikedavem/p13196/sql-server-2012/dealing-with-sql-server-on-linux-on-wsl2
I get error at below point.


75400-image.png



image.png (27.4 KiB)
·
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.