Install SQL Server ...
 
Notifications
Clear all

Install SQL Server on Linux VM

Raju
 Raju
(@raju)
Member Admin

Install SQL Server on Linux VM

wget -qO-  https://packages.microsoft.com/keys/microsoft.asc  | sudo apt-key add -

sudo add-apt-repository "$(wget -qO-  https://packages.microsoft.com/config/ubuntu/18.04/mssql-server-2019.list )"
sudo apt-get update
sudo apt-get install -y mssql-server
sudo /opt/mssql/bin/mssql-conf setup


### Command line Tools 

sudo apt install curl
curl  https://packages.microsoft.com/keys/microsoft.asc  | sudo apt-key add -
curl  https://packages.microsoft.com/config/ubuntu/18.04/prod.list  | sudo tee /etc/apt/sources.list.d/msprod.list
sudo apt-get update 
sudo apt-get install mssql-tools unixodbc-dev
echo 'export PATH="$PATH:/opt/mssql-tools/bin"' >> ~/.bash_profile
echo 'export PATH="$PATH:/opt/mssql-tools/bin"' >> ~/.bashrc
source ~/.bashrc
sqlcmd -S localhost -U SA -P '<YourPassword>'



### Verification


$ 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 Mon 2022-11-28 03:18:18 UTC; 4min 15s ago
     Docs:  https://docs.microsoft.com/en-us/sql/linux 
 Main PID: 29796 (sqlservr)
    Tasks: 134
   CGroup: /system.slice/mssql-server.service
           ├─29796 /opt/mssql/bin/sqlservr
           └─29836 /opt/mssql/bin/sqlservr

Nov 28 03:18:21 H1BWebServer sqlservr[29796]: [158B blob data]
Nov 28 03:18:21 H1BWebServer sqlservr[29796]: [155B blob data]
Nov 28 03:18:21 H1BWebServer sqlservr[29796]: [61B blob data]
Nov 28 03:18:22 H1BWebServer sqlservr[29796]: [96B blob data]
Nov 28 03:18:22 H1BWebServer sqlservr[29796]: [66B blob data]
Nov 28 03:18:22 H1BWebServer sqlservr[29796]: [75B blob data]
Nov 28 03:18:22 H1BWebServer sqlservr[29796]: [96B blob data]
Nov 28 03:18:22 H1BWebServer sqlservr[29796]: [100B blob data]
Nov 28 03:18:22 H1BWebServer sqlservr[29796]: [71B blob data]
Nov 28 03:18:22 H1BWebServer sqlservr[29796]: [124B blob data]

References :

 
This topic was modified 1 year ago by Raju
Quote
Topic starter Posted : 04/12/2022 4:17 am
Share: