Installing MS SQL Server along with Azure Data Studio on Arch Linux requires a combination of Microsoft packages and some extra tweaks since SQL Server isn’t natively available for Arch and Azure Data Studio is mainly targeted for Debian/Red Hat based distros.
Step 1: Install Azure Data Studio
Azure Data Studio is available via AUR.
yay -S azure-data-studio-bin
This installs the latest prebuilt version from Microsoft.
Option 2: Manual (optional)
If you want to manually install:
- Download .tar.gz from Azure Data Studio official packages
- Extract it:
tar -xvzf azuredatastudio-linux-x64.tar.gz
cd azuredatastudio-linux-x64
./azuredatastudio
Step 2: Install Microsoft SQL Server (Docker Method – Recommended)
Microsoft SQL Server is not supported natively on Arch, but the Docker container is fully functional and easiest to manage.
- Install Docker if you haven’t:
sudo pacman -S docker
sudo systemctl enable --now docker
sudo usermod -aG docker $USER
newgrp docker
- Pull SQL Server Image:
docker pull mcr.microsoft.com/mssql/server:2022-latest
- Run the Container:
docker run -e "ACCEPT_EULA=Y" -e "SA_PASSWORD=YourStrong!Passw0rd" \
-p 1433:1433 --name sql_server \
-d mcr.microsoft.com/mssql/server:2022-latest
Note: Make sure to use a strong password (uppercase, lowercase, number, symbol, and >8 characters).
Step 3: Connect SQL Server to Azure Data Studio
- Launch Azure Data Studio.
- Click on New Connection.
- Fill out the fields:
- Server:
localhost - Authentication:
SQL Login - User:
sa - Password:
YourStrong!Passw0rd
- Hit Connect
Step 4: (Optional) Autostart Docker with Hyprland
If you want SQL Server to start with your system:
sudo systemctl enable docker
Or add a Hyprland hook to start the container at login:
docker start sql_server
Conclusion
You now have a fully functional SQL Server instance running on Arch Linux via Docker, and you can manage it using Azure Data Studio. This setup allows you to leverage the power of SQL Server without needing to run a full Windows environment.