Skip to content

Instantly share code, notes, and snippets.

@tskxz
Created February 16, 2024 10:54
Show Gist options
  • Save tskxz/9c58123ca4dc07f6afc83d008db4e75e to your computer and use it in GitHub Desktop.
Save tskxz/9c58123ca4dc07f6afc83d008db4e75e to your computer and use it in GitHub Desktop.
SQL SERVER DEBIAN
sudo wget https://packages.microsoft.com/keys/microsoft.asc -O /etc/apt/keyrings/mssql2022.key
sudo wget https://packages.microsoft.com/config/ubuntu/22.04/mssql-server-2022.list -O /etc/apt/sources.list.d/mssql-server-2022.list
sudo wget https://packages.microsoft.com/config/ubuntu/22.04/prod.list -O /etc/apt/sources.list.d/msprod.list
sudo nano /etc/apt/sources.list.d/mssql-server-2022.list
# add setting like follows
deb [signed-by=/etc/apt/keyrings/mssql2022.key arch=amd64,armhf,arm64] https://packages.microsoft.com/ubuntu/22.04/mssql-server-2022 jammy main
sudo nano /etc/apt/sources.list.d/msprod.list
# add setting like follows
deb [signed-by=/etc/apt/keyrings/mssql2022.key arch=amd64,armhf,arm64] https://packages.microsoft.com/ubuntu/22.04/prod jammy main
sudo apt update
sudo apt -y install mssql-server mssql-tools unixodbc-dev
/opt/mssql/bin/mssql-conf setup
sudo -s
echo 'export PATH=$PATH:/opt/mssql-tools/bin' > /etc/profile.d/mssql.sh
source /etc/profile.d/mssql.sh
sqlcmd -S localhost -U SA
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment