Easy-to-use graphical management tool for managing SQL Server

SQL Server Management Studio

SQL Server Management Studio

  -  5.5 MB  -  Freeware
Microsoft SQL Server Management Studio Express (SSMS) is a free, integrated environment for accessing, configuring, managing, administering, and developing all components of SQL Server, as well as combining a broad group of graphical tools and rich script editors that provide access to the Server to developers and administrators of all skill levels. 

Originally introduced to the public as the part of the Microsoft SQL Server 2005, this app enabled professional users to easily manage, administer and configure all components of the Microsoft SQL Server Platform, with access to tools such script editors, graphical tools and everything needed to interact with objects and database features.

The latest version of this app managed to completely integrate itself with all the features and additions that were introduced with the arrival of the SQL Server 2012, enabling users from all around the world to easily manage both their old and new database-related projects of all shapes and sizes.

Microsoft SQL Server Management Studio Express (SSMSE) is an integrated environment for accessing, configuring, managing, administering, and developing all components of the Server.

The software combines a broad group of graphical tools with a number of rich script editors to provide access to SQLServer to developers and administrators of all skill levels.

Developers get a familiar experience, and database administrators get a single comprehensive utility that combines easy-to-use graphical tools with rich scripting capabilities.

Supported SQL offerings

This version of SSMS supports SQL Server 2014 (12.x) and later, with extensive compatibility for cloud features like Azure SQL Database, Azure Synapse Analytics, and Microsoft Fabric.

Key highlights:

Parallel Installations: SSMS 20.x can coexist with earlier versions, including SSMS 19.x, 18.x, 17.x, and 16.x.

Integration Services (SSIS):
  • SSMS 17.x and later don't support connections to legacy SQL Server Integration Services services. For earlier versions, use the corresponding SSMS version (e.g., SSMS 16.x for SQL Server 2016 Integration Services).
  • Since SQL Server 2012, the recommended method for managing SSIS packages is the SSIS Catalog database (SSISDB).
Uninstall

SSMS might install shared components if it determines they're missing during SSMS installation. SSMS doesn't automatically uninstall these components when you uninstall SSMS.

The shared components are:
  • Microsoft OLE DB Driver 18 for SQL Server
  • Microsoft ODBC Driver 17 for SQL Server
  • Microsoft Visual C++ 2017 Redistributable (x86)
  • Microsoft Visual C++ 2017 Redistributable (x64)
  • Microsoft Visual Studio Tools for Applications 2019
System Requirements

The current release of SSMS supports the following 64-bit platforms when used with the latest available service pack:

Supported operating systems:
  • Windows 11 (x64)
  • Windows 10 (x64) version 1607 (10.0.14393) and later versions
  • Windows Server 2022 (x64)
  • Windows Server Core 2022 (x64)
  • Windows Server 2019 (x64)
  • Windows Server Core 2019 (x64)
  • Windows Server 2016 (x64) 1
  • 1 SSMS requires .NET Framework 4.7.2.
Supported hardware:

1.8 GHz or faster x86 (Intel, AMD) processor. Dual-core or better recommended

2 GB of RAM; 4 GB of RAM recommended (2.5 GB minimum if running on a virtual machine)

Hard disk space: Minimum of 3 GB up to 10 GB of available space

Additional requirements:
  • Administrator rights are required to install or update SSMS.
  • Running in a virtual machine environment requires a full Windows operating system.
  • Windows containers are not supported.
  • SSMS is not supported in application virtualization solutions such as Microsoft App-V or MSIX for Windows, or third-party app virtualization technologies.
PROS
  • Intuitive user interface
  • Robust debugging tools
  • Excellent query performance tuning
  • Advanced reporting features
  • Wide integration support
CONS
  • High system resource usage
  • Limited cross-platform compatibility
  • Occasional lag with large databases
  • Expensive licensing for enterprise
Note: Requires .NET Framework.

Why is this app published on FileHorse? (More info)
  • SQL Server Management Studio 22.5.0 Screenshots

    The images below have been resized. Click on them to view the screenshots in full size.

    SQL Server Management Studio 22.5.0 Screenshot 1
  • SQL Server Management Studio 22.5.0 Screenshot 2
  • SQL Server Management Studio 22.5.0 Screenshot 3
  • SQL Server Management Studio 22.5.0 Screenshot 4
  • SQL Server Management Studio 22.5.0 Screenshot 5

What's new in this version:

New:
- Added 74 new item templates for SQL projects, covering a programmability, security, storage, tables, and views
- Added importing objects from an existing database into a SQL project
- Added the Advanced Publish Settings dialog (publish properties) to the Publish Database dialog
- Added support for custom endpoint entry in Tools > Options > Environment > Account > Registered Azure Clouds
- Addressed exception Object reference not set to an instance of an object that occurred when opening the Extended Events filter, see Exception occurs on the Extended Events filter
- Addressed an issue where the monthly limit for the chat had the incorrect date, see SSMS 22.1 GitHub Copilot Chat monthly limit message contradiction (GHCP).
- Addressed an issue where Solution Explorer became blank after opening a file, see Solution Explorer is blank when opening solution from git repo..

Improved:
- Updated the connection dialog to clear the custom name when either the server name, authentication type, username or database name fields change
- Updated the SQL database project icon to use a fluent design
- Improved context handling to only send contents of the active editor for code completions
- Introduced support for interacting with the results pane from the chat window, including execution plan, messages, client statistics, and the results grid
- Introduced the Migrate SQL Server to Azure SQL capability that enables offline migration readiness assessment and supports migration of SQL Server workloads to Azure using existing SSMS wizards or the Azure Database Migration Service. For Azure Arc-managed SQL Server instances, users can view migration readiness assessments and perform migrations through the Azure portal.
- For security issues addressed in this release, see the Visual Studio release notes
- Updated to Visual Studio 18.5.0 [11707.296]
- Solution Explorer now opens automatically when a database project is created
- Model selection now persists after clearing chat or starting a new thread, see GitHub Copilot Chat always selects Claude instead of last used Model (GHCP).

Fixed:
- Resolved an issue where the Execution time-out (seconds) setting, in Tools > Options > Query Execution > Analysis Server, was not respected in the query editor
- Resolved an issue where DTA didn't start with error Failed to open a new connection
- Resolved an application hang that occurred during a rename operation
- Resolved an issue where Object Explorer menus weren't localized, see 22.4.1 The language of the Object Explorer does not match the language of the regional settings..
- Fixed improperly truncated error messages during publish failures
- Fixed the generate script dialog appearing frozen during the process
- Fixed an issue where Ctrl+R didn't open the Filter dialog in the Extended Events viewer, see SSMS22: Ctrl+R does not work for Extended Events
- Fixed a stack overflow crash in Microsoft.SqlServer.Management.SqlParser.dll
- Fixed an issue where chat messages weren't showing even though the chat title was displayed, see GitHub Copilot Chat messages not showing in SSMS 22 even though chat title shows.
- Fixed a typo within the Portuguese (Brazil) connection dialog, see Typo in Portuguese (Brazil) localization: "Ravoritas" instead of "Favoritas".
- Fixed a localization issue where the job schedule frequency dialog was obscured