Quick Answer
SQL Management Studio (SSMS) is Microsoft's free tool for managing SQL Server databases. Download the latest version from learn.microsoft.com. File size: approximately 600 MB. Supports Windows 10 and Windows 11. Current version: SSMS 21 (2026).
- 1Go to learn.microsoft.com and search for SSMS download
- 2Click the free download link for SSMS 21
- 3Run the downloaded installer file
- 4Click Install and wait for completion (10-20 minutes)
- 5Launch from Start menu and connect to your SQL Server
What Is SQL Management Studio
SQL Management Studio, officially known as SQL Server Management Studio (SSMS), is Microsoft's primary graphical interface for working with SQL Server databases. It provides a comprehensive environment for managing all aspects of SQL Server — from writing and executing queries to configuring server settings and managing user permissions.
Database administrators, developers, and data analysts use SQL Management Studio daily to interact with their databases. It is the standard tool for anyone working in the Microsoft SQL Server ecosystem, whether on-premises or in Azure.
SQL Management Studio Versions
| Version | Release Year | Status | Supported SQL Server |
|---|---|---|---|
| SSMS 21 | 2026 | Current — Recommended | SQL Server 2016 through 2022, Azure SQL |
| SSMS 20 | 2024 | Supported | SQL Server 2014 through 2022, Azure SQL |
| SSMS 19 | 2023 | Older — still functional | SQL Server 2012 through 2022 |
| SSMS 18 | 2019-2022 | Older — consider upgrading | SQL Server 2008 through 2019 |
How to Download SQL Management Studio
Open the Microsoft SSMS Download Page
Open your web browser and navigate to learn.microsoft.com. Search for "SSMS download" or go directly to the SQL Server Management Studio download page in the Microsoft documentation.
Find the Download Link
On the SSMS download page, find the link labeled "Free Download for SQL Server Management Studio (SSMS) 21" or the current version. The link is prominently displayed near the top of the page.
Download the Installer
Click the download link to download the SSMS installer file (SSMS-Setup-ENU.exe). The file is approximately 600 MB and may take a few minutes depending on your internet speed.
Run the Installer
Locate the downloaded file in your Downloads folder and double-click it. If prompted by User Account Control, click Yes to allow the installation to proceed with administrator privileges.
Click Install
The SSMS setup wizard will open. Click Install to begin with default settings. The installation process takes 10-20 minutes. Do not interrupt it.
Restart if Required
After installation, you may be prompted to restart your computer. Save any open work and restart to complete the installation.
Launch SQL Management Studio
After the computer restarts, search for "SQL Server Management Studio" or "SSMS" in the Start menu and click to launch it.
Your First Connection to SQL Server
When SSMS opens for the first time, the Connect to Server dialog appears:
| Field | What to Enter |
|---|---|
| Server type | Database Engine (default) |
| Server name (local) | . (period) or localhost or COMPUTERNAME\SQLEXPRESS |
| Server name (remote) | Server hostname or IP, e.g. DBSERVER01 |
| Authentication (domain) | Windows Authentication |
| Authentication (SQL login) | SQL Server Authentication + username/password |
System Requirements for SQL Management Studio 2026
| Component | Requirement |
|---|---|
| Operating System | Windows 10 (version 1607+) or Windows 11 |
| Processor | 1.8 GHz or faster, x86 or x64 |
| RAM | 4 GB minimum, 8 GB recommended |
| Disk Space | 2-3 GB available space |
| .NET Framework | .NET Framework 4.7.2 or higher |
| Display | 1280 x 720 minimum resolution |
Common SQL Management Studio Tasks
Here are the most common tasks performed in SQL Management Studio:
- Run a SELECT query: Open a New Query window, type your query, and press F5.
- Create a new table: Right-click Tables under your database in Object Explorer and select New Table.
- Back up a database: Right-click the database, go to Tasks > Back Up.
- View stored procedures: Expand your database in Object Explorer, then expand Programmability > Stored Procedures.
- Create a new login: Expand Security > Logins at the server level, right-click and select New Login.
- View query execution plan: Press Ctrl + M before running a query to see the actual execution plan.
Frequently Asked Questions
Frequently Asked Questions
SQL Management Studio (officially SQL Server Management Studio or SSMS) is a free graphical tool from Microsoft for managing SQL Server databases. It allows database administrators and developers to connect to SQL Server instances, write and execute T-SQL queries, manage database objects, configure security, create backups, and monitor server performance.