You are viewing a free preview of this lesson.
Subscribe to unlock all 10 lessons in this course and every other course on LearningBro.
This lesson covers how to install SQL Server, configure your instance, and connect using various client tools. Whether you are on Windows, Linux, or Docker, you will have a working SQL Server environment by the end.
| Method | Platform | Best For |
|---|---|---|
| SQL Server Installer | Windows | Traditional on-premises setup |
| apt / yum packages | Linux (Ubuntu, RHEL) | Linux-native deployment |
| Docker | Windows, macOS, Linux | Quick development setup |
| Azure SQL Database | Cloud | Fully managed, no installation needed |
For more control, choose Custom to open the SQL Server Installation Centre:
Tip: Choose Mixed Mode authentication if you need SQL logins (username/password) in addition to Windows authentication.
SQL Server runs on Ubuntu, RHEL, and SUSE Linux:
# Ubuntu example
sudo apt-get update
sudo apt-get install -y mssql-server
# Run the setup
sudo /opt/mssql/bin/mssql-conf setup
# Verify
systemctl status mssql-server
Install the command-line tools:
sudo apt-get install -y mssql-tools unixodbc-dev
# Add to PATH
echo 'export PATH="$PATH:/opt/mssql-tools/bin"' >> ~/.bashrc
source ~/.bashrc
The fastest way to get started:
docker run -e "ACCEPT_EULA=Y" -e "MSSQL_SA_PASSWORD=YourStrong!Password" \
-p 1433:1433 --name sql-server \
-d mcr.microsoft.com/mssql/server:2022-latest
Check the container is running:
docker ps
docker logs sql-server
Tip: Docker is ideal for development and testing. Use the official Microsoft container image from the Microsoft Container Registry (MCR).
SQL Server Management Studio (SSMS) is the primary GUI for SQL Server on Windows:
localhost (or localhost\InstanceName for named instances)Subscribe to continue reading
Get full access to this lesson and all 10 lessons in this course.