setup-MS-SQLServer-2022-On-Ubuntu-20_04.md

Setup Microsoft SQL Server 2022 on Ubuntu 20.04

---

YouTube Setup Microsoft SQL Server 2022 on Ubuntu 20.04 🔗 https://youtu.be/QuP8k66pYdM

---

SUPPORT MY WORK - Everything Helps Thanks YouTube 🔗 https://YouTube.GetMeTheGeek.com
Buy Me a Coffee ☕ https://www.buymeacoffee.com/getmethegeek
Hire US 🔗 https://getmethegeek.com

---

Update Ubuntu

sudo apt update
sudo apt upgrade -y
sudo reboot

Import Microsoft public repository GPG key for Ubuntu

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

Register the Microsoft SQL Server Ubuntu repository for SQL Server 2022

sudo add-apt-repository "$(wget -qO- https://packages.microsoft.com/config/ubuntu/20.04/mssql-server-2022.list)"

Install SQL Server

sudo apt update
sudo apt install -y mssql-server

Configure SQL server and set SA password

sudo /opt/mssql/bin/mssql-conf setup

Check SQL service is running

systemctl status mssql-server --no-pager

Check the listening port for MSSQL server

sudo apt install net-tools
sudo netstat -tnlp | grep sqlservr

Open up the firewall port 1433 to connect remotely

Allow ssh and enable firewall

sudo ufw allow 22
sudo ufw allow 1433
sudo ufw allow 1434
sudo ufw enable

Install SQL Server command-line tools

Import the public repository GPG keys.

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

Register the Microsoft Ubuntu repository

curl https://packages.microsoft.com/config/ubuntu/20.04/prod.list | sudo tee /etc/apt/sources.list.d/msprod.list

Install tools and ODBC drivers

sudo apt update 
sudo apt install -y mssql-tools unixodbc-dev

Add tools folder to PATH environment variable in a bash shell.

echo 'export PATH="$PATH:/opt/mssql-tools/bin"' >> ~/.bash_profile
echo 'export PATH="$PATH:/opt/mssql-tools/bin"' >> ~/.bashrc
source ~/.bashrc

Connect to your server

sqlcmd -S localhost -U sa -P 'Password'

If successful, you should get a command prompt: 1>.

Attaching existing SQL Server Database

Copy yourdbname.mdf and yourdbname_log.ldf to the /var/opt/mssql/data/ directory. Set the owner and permissions to mssql.

sudo cp yourdbname* /var/opt/mssql/data/
sudo su
Chown mssql:mssql /var/opt/mssql/data/yourdbname*
chmod u=+rw,g=+rw,o=-rw  /var/opt/mssql/data/yourdbname*

Run sql on the master

USE master;

CREATE DATABASE yourdbname 
ON PRIMARY (FILENAME = '/var/opt/mssql/data/yourdbname.mdf'),
   (FILENAME = '/var/opt/mssql/data/yourdbname_log.ldf') 
FOR ATTACH

hi everybody
tell this error to me
Failed to start Microsoft SQL Server Database Engine

Hi

Getting this error

ubuntu@ip-172-31-12-97:~$ sqlcmd -S localhost -U sa
Password:
Sqlcmd: Error: Microsoft ODBC Driver 18 for SQL Server : SSL Provider: [error:0A000086:SSL routines::certificate verify failed:self-signed certificate].
Sqlcmd: Error: Microsoft ODBC Driver 18 for SQL Server : Client unable to establish connection. For solutions related to encryption errors, see https://go.microsoft.com/fwlink/?linkid=2226722.

Hi kstevenson722, thank you for sharing.

When I execute this command:

sudo /opt/mssql/bin/mssql-conf setup

I get this error:

/opt/mssql/bin/sqlservr: error while loading shared libraries: liblber-2.4.so.2: cannot open shared object file: No such file or directory

do you have any idea?

System: Ubuntu 22.04.3 LTS, 64-bit

UPDATE: I needed to install libldap: http://http.us.debian.org/debian/pool/main/o/openldap/libldap-2.4-2_2.4.47+dfsg-3+deb10u7_amd64.deb

Then ssl:

   wget http://nz2.archive.ubuntu.com/ubuntu/pool/main/o/openssl/libssl1.1_1.1.1f-1ubuntu2.19_amd64.deb
   sudo dpkg -i libssl1.1_1.1.1f-1ubuntu2.19_amd64.deb

Thanks a lot