Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Applies to: 
SQL Server
Azure SQL Database
Azure SQL Managed Instance
Azure Synapse Analytics
SQL Server Management Studio (SSMS) is an integrated environment for managing any SQL infrastructure. Use SSMS to accessconfiguremanageadministerand develop all components of SQL ServerAzure SQL DatabaseAzure SQL Managed InstanceSQL Server on Azure Virtual MachinesSQL database in Microsoft Fabricand Azure Synapse Analytics.
SSMS provides a single comprehensive utility that combines a broad group of graphical tools with many rich script editors to provide access to SQL Server for developers and database administrators of all skill levels. For more informationsee Components and features in SQL Server Management Studio.
Install SQL Server Management Studio
Download SQL Server Enterprise Developer or Standard Developer edition
What you can do with SSMS
SSMS brings together graphical tools and rich editors to help you:
- Connect securely to SQL ServerAzure SQLand related services. Manage objects by using Object Explorer and design tools.
- Queryscriptand tune workloads by using the Query Editorexecution plansand built-in performance tools.
- Administer business intelligence features such as Integration Services (SSIS)Analysis Services (SSAS)and Reporting Services (SSRS).
Components and features
Explore the full set of capabilitiesincluding AI assistanceperformance toolssource controland BI administrationin Components and features in SQL Server Management Studio.
Highlights in SSMS 22
| Feature | Description | Article |
|---|---|---|
| AI assistance (Preview) | GitHub Copilot in SSMS adds chat and right-click code actionsplus model selection and BYOM. | Get started with GitHub Copilot in SQL Server Management Studio (Preview) |
| Query Hint Recommendation (Preview) | Assess queries and apply recommended hints. | Query Hint Recommendation tool (Preview) |
| Modern connection experience | Updated dialogFabric browsingand improved encryption visibility. | Connect to a SQL Server instance |
For full details of the latest featuressee Release notes for SQL Server Management Studio (SSMS).
Administer SSISSSASand SSRS
Use SSMS to viewconfigureand administer SQL Server Integration Services (SSIS)SQL Server Analysis Services (SSAS)and SQL Server Reporting Services (SSRS) at the server level.
For development of packagesmodelsor reportsuse SQL Server Data Tools (SSDT).
Note
Starting with SQL Server 2025 (17.x)on-premises reporting services are consolidated under Power BI Report Server. For more informationsee Reporting Services consolidation FAQ.
Non-English language versions
The Visual Studio Installer selects a default language pack for SSMS that matches the language of your operating system. You can change the default language at any time. For more informationsee Modify SQL Server Management Studio workloadscomponentsand language packs.
Support policy
The SQL Tools team follows the Microsoft Modern Lifecycle Policy.
For more informationsee the original Modern Lifecycle Policy announcement and the Modern Policy FAQs.
For diagnostic data collection and feature usage informationsee the SQL Server privacy supplement and diagnostic data collection.
Get help
- Ideas for SQL: Have suggestions for improving SQL Server?
- Microsoft Q & A (SQL Server)
- DBA Stack Exchange (tag sql-server): Ask SQL Server questions
- Stack Overflow (tag sql-server): Answers to SQL development questions
- Reddit: General discussion about SQL Server
- Microsoft SQL Server License Terms and Information
- Support options for business users
- Additional SQL Server help and feedback
Contribute to SQL documentation
Did you know that you can edit SQL content yourself? If you do sonot only do you help improve our documentationbut you also get credited as a contributor to the page.
For more informationsee Edit Microsoft Learn documentation.