Notifications
Clear all
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 :
Troubleshooting
connection Troubleshooting
Restore Database
This topic was modified 3 years ago by Raju
Topic starter
Posted : 04/12/2022 4:17 am