Download SQL Server Express Editions
Estimated study time: 4 minutes. Get SQL Server running on your machine in a few simple steps.
SQL Server Express is a free, lightweight edition of SQL Server that's perfect for learning, small applications, and development work.
Step 1: Go to the Official Download Page
Visit Microsoft's official SQL Server downloads page and select the Express edition.
Step 2: Choose an Installation Type
You'll typically see three options:
- Basic — installs SQL Server Express with default settings. Recommended for beginners.
- Custom — lets you configure installation options manually.
- Download Media — downloads the installer files without starting setup, useful for offline installs.
Step 3: Run the Installer
Choose Basic, accept the license terms, and let the installer download and configure everything automatically. Note the instance name shown at the end (commonly SQLEXPRESS) — you'll need it to connect.
Step 4: Install SQL Server Management Studio (SSMS)
SSMS doesn't come bundled with Express by default. Download it separately from Microsoft and install it so you have a graphical tool to write and run queries.
Step 5: Connect to Your Server
Server name: .\SQLEXPRESS Authentication: Windows Authentication