Lou's lab

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
====== SQL Server op Linux======
[[sql:sql|{{ :sql:icon.jpg?120|}}]]

===== context=====
dit document beschrijft de installatie van MS SQL Server op Linux
===== voorbereiding =====
  - maak een [[linux:installatie_debian10_vanaf_een_template|Linux VM]] aan:
    - 2 cores
    - 4Gb RAM
  - voeg de MSSQL repository toe: 
    - <code>wget -qO- https://packages.microsoft.com/keys/microsoft.asc | sudo apt-key add -</code>
    - <code>sudo add-apt-repository "$(wget -qO- https://packages.microsoft.com/config/ubuntu/18.04/mssql-server-2019.list)"</code>
===== installatie =====
  - installeer MSSQL:<code>sudo apt-get update && apt-get install -y mssql-server</code>
  - voer uit: <code>sudo /opt/mssql/bin/mssql-conf setup</code>
  - kies: **2)** Developer
  - aanvaard de gebruikersovereenkomst
  - kies een administrator (**SA**) wachtwoord
  - controleer de status van de mssql server: <code>sudo systemctl status mssql-server --no-pager
● mssql-server.service - Microsoft SQL Server Database Engine
   Loaded: loaded (/lib/systemd/system/mssql-server.service; enabled; vendor preset: enabled)
   Active: active (running) since Thu 2020-11-26 21:13:32 UTC; 59s ago
     Docs: https://docs.microsoft.com/en-us/sql/linux
 Main PID: 31621 (sqlservr)
    Tasks: 137
   CGroup: /system.slice/mssql-server.service
           ├─31621 /opt/mssql/bin/sqlservr
           └─31663 /opt/mssql/bin/sqlservr
...</code>





===== meer info =====
  * [[https://docs.microsoft.com/en-us/sql/linux/quickstart-install-connect-ubuntu?view=sql-server-linux-ver15|installatie MSSQL op Ubuntu]]

{{tag>Linux sql microsoft}}