How to Install and Use Microsoft SQL Server on Debian 11

MSSQL Server or Microsoft SQL Server is an RDBMS (Relational Database Management System) developed by Microsoft. As a database server, it is used to store data for your applications. The SQL Server is ideal for multiple purposes of applications, you can use MS SQL Server as the database for your desktop applications, use it for your web applications, or any small server applications.

This video will show you how to install and use Microsoft SQL database Server on Debian 11

Commands Used
sudo apt update
sudo apt install gnupg2 apt-transport-https wget curl

wget -q -O- https://packages.microsoft.com/keys/microsoft.asc |
gpg –dearmor | sudo tee /usr/share/keyrings/microsoft.gpg /dev/null 2&1

echo “deb [signed-by=/usr/share/keyrings/microsoft.gpg arch=amd64,armhf,arm64] https://packages.microsoft.com/ubuntu/20.04/mssql-server-2019 focal main” |
sudo tee /etc/apt/sources.list.d/mssql-server-2019.list

sudo apt update
sudo apt install mssql-server
sudo /opt/mssql/bin/mssql-conf setup
sudo systemctl is-enabled mssql-server
sudo systemctl status mssql-server
sudo apt install ufw
sudo ufw allow OpenSSH
sudo ufw allow 1433/tcp
sudo ufw enable
sudo ufw status

echo “deb [signed-by=/usr/share/keyrings/microsoft.gpg arch=amd64,armhf,arm64] https://packages.microsoft.com/ubuntu/20.04/prod focal main” |
sudo tee /etc/apt/sources.list.d/prod.list

sudo apt update
sudo apt install mssql-tools unixodbc-dev
ls /opt/mssql-tools/bin

echo ‘export PATH=”$PATH:/opt/mssql-tools/bin”‘ ~/.bashrc
source ~/.bashrc
echo $PATH
which sqlcmd
which bcp

Useful Links
VPS/VDS – https://www.mivocloud.com/