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 2 years ago by Raju
Topic starter
Posted : 04/12/2022 4:17 am