Short answer: SQL Server Management Studio, or SSMS, is the free Microsoft tool for managing and querying SQL Server, Azure SQL and Fabric databases. We'd download SSMS 22 from Microsoft Learn. Setup runs through the Visual Studio Installer. You need Windows 11 or Windows Server 2019 or later. For a local instance, type a dot as the server name.
SQL Server Management Studio (SSMS) is Microsoft’s free Windows app for managing SQL Server and Azure SQL databases, and the current release, SSMS 22, is a free download from Microsoft Learn. For many database people, SQL Server Management Studio is the window that stays open more hours a day than email. SSMS for short. You’d run the current release, SSMS 22, on 64-bit Windows 11 or on Windows Server 2019 and later.
- Download: the free SSMS 22 bootstrapper from Microsoft Learn.
- Install: run
vs_SSMS.exe, the real download happens inside. - Connect: a single dot as the server name reaches the local instance.
- Learn: Object Explorer and the query editor first.
It’s Microsoft’s free Windows application for managing SQL Server, Azure SQL and Microsoft Fabric databases.
You connect, write T-SQL, design tables, schedule jobs and read execution plans in one place.
The current version is SSMS 22. The latest build at the time of writing is 22.11.3 from October 29, 2026. It costs nothing and needs no license.
Long-time users remember older SSMS releases, back when it still shipped inside the SQL Server installer.
Below: where to download it safely, what hardware and Windows version it needs, setup and the first connection. That last requirement changed with version 22.
Then come the features worth learning and Copilot. After that, the alternatives now that Azure Data Studio is gone, and fixes for the most common errors people run into.
| Point | What to know |
|---|---|
| Price | SSMS 22 is free for any use, from a student laptop to a production DBA team |
| Runs on | 64-bit Windows 11, Arm64 included, and Windows Server 2019, 2022 and 2025. Windows 10 and Server 2016 aren’t on the list any more |
| Manages | SQL Server 2014 through SQL Server 2025, plus Azure SQL Database, Managed Instance, Synapse and Fabric |
| Azure Data Studio | Gone. Microsoft now points to Visual Studio Code with the MSSQL extension for Mac and Linux |
| GitHub Copilot | Built in: chat has been generally available since 22.4.1, Agent Mode since 22.10.2 |
| Fact | SSMS 22 |
|---|---|
| Latest build, November 2026 | 22.11.3, released October 29, 2026 |
| First release | 22.0.0, November 11, 2025 |
| Price | Free, no license required |
| Windows versions | Windows 11 x64 and Arm64; Windows Server 2019, 2022, 2025 |
| Manages | SQL Server 2014 to 2025, Azure SQL, Synapse, Microsoft Fabric |
| Installer | The vs_SSMS.exe bootstrapper, which starts the Visual Studio Installer |
| Shell | Visual Studio 2026, version 18.x |
What SSMS is used for
It administers and queries Microsoft SQL databases. DBAs, developers and analysts all use it daily.
| Job | Where in SSMS |
|---|---|
| Browse databases and objects | Object Explorer |
| Write and run T-SQL | The query editor |
| Create tables and indexes | Designers and scripts |
| Manage logins and permissions | The Security nodes |
| Schedule backups | SQL Server Agent |
| Analyse slow queries | Execution plans |
SQL Server is the engine that stores and processes data. SSMS is the interface on top.
You get menus and right-click actions if you like a GUI, and a query editor if you type. Many people switch between both all day.
A quick SELECT goes into the editor. To see which indexes exist on a table, a right-click in Object Explorer beats typing a query against sys.indexes.
A bit of history explains the version numbers. Microsoft bundled SSMS with the SQL Server installer from 2005 until 2016.
Before that the tool was Enterprise Manager, and it wasn’t pleasant.
In 2016 SSMS became a separate download, so it could be updated without waiting for a SQL Server release. Since then updates arrive roughly every few weeks.
SSMS 21 moved to the Visual Studio Installer and 64-bit. SSMS 22 moved to the Visual Studio 2026 shell.
One window can hold three very different servers at once: a local developer instance, a staging server and a production Azure SQL Database.
Downloading it for free
The download comes from Microsoft Learn. There’s no trial and no paid edition.
- Open the Install SQL Server Management Studio page on Microsoft Learn.
- Click the SSMS 22 download link. You get a small bootstrapper of a few megabytes.
- Save it and run it. The real download happens inside the installer.
| Item | Value |
|---|---|
| File | vs_SSMS.exe |
| Direct link Microsoft publishes | aka.ms/ssms/22/release/vs_SSMS.exe |
| Size of the real download | Typically a few gigabytes, depending on the workloads you choose |
Don’t download SSMS from mirror sites. Some hand out old builds wrapped with a browser toolbar or other extras.
Microsoft Learn or the aka.ms link, nothing else.
Releases ship in two channels, Release and Preview. Unless you want to test fresh features, we’d stay on Release. Both can sit side by side on one PC.
SSMS 22 system requirements
Installing requires administrator rights.
| Component | Minimum | Recommended |
|---|---|---|
| Operating system | Windows 11 64-bit: Home, Pro, Enterprise, Education, Arm64 included; Windows Server 2019, 2022 or 2025, Standard or Datacenter | Windows 11 24H2 or 25H2, or Windows Server 2025 |
| Processor | x64 or Arm64; no Arm32 | Quad-core or better |
| RAM | 4 GB | 16 GB |
| Disk space | 4 GB | 20 GB to 50 GB, on an SSD |
| Display | 1366 x 768 | 1920 x 1080 or higher |
| .NET Framework | 4.7.2 to install | 4.8 to run; setup adds it |
The big change is the operating system list. Microsoft’s SSMS 22 system requirements name Windows 11 and Windows Server 2019 or later only.
| Absent from the list |
|---|
| Windows 10 and Windows Server 2016 |
| LTSC editions and Windows in S mode |
| 32-bit Windows |
| Multi-user setups such as shared VDI or multi-session Azure Virtual Desktop |
On a system outside the list the installer may still run. You’re on your own if something breaks, though.
The Arm64 build comes as a pleasant surprise. People with a Snapdragon X laptop expect to run SSMS under x64 emulation.
The native Arm64 version is already there and runs fine.
Microsoft also asks you to keep Windows Smart App Control off. Any other setting can slow SSMS down.
Older versions don’t get in the way. SSMS 22 goes on side by side with SSMS 21, 20, 19, 18 and older.
SSMS 20 can stay installed next to 22. The two versions sit side by side without a conflict.
How to install SQL Server Management Studio
On a clean Windows 11 machine the whole process takes around fifteen minutes, mostly download time.

- Run
vs_SSMS.exeas an administrator. Approve the User Account Control prompt. - Wait for the Visual Studio Installer. On a first run it fetches its own components before showing options.
- Pick workloads, if you want any. The base setup works without them.
- Set the install location. The default is the system drive. Moving it later takes a reinstall.
- Click Install. Get a coffee.
- Restart if asked. It isn’t always needed, but we’d do it after a first setup.
- Start SSMS. Search for “SQL Server Management Studio 22” in the Start menu.
| Workload | What it adds |
|---|---|
| AI Assistance | GitHub Copilot |
| Hybrid and migration | Tools for moving and connecting environments |
| Database DevOps | Project and pipeline tools |
| Integration Services | SSIS tooling |
The first connection
On first launch you’re offered a sign-in. Skip it unless you plan to use Copilot. The connection dialog is what matters.
| Target | Server name to type |
|---|---|
| A local default instance | A single dot: . |
| A local named instance | .\SQLEXPRESS |
| A named instance on another machine | MACHINENAME\INSTANCENAME |
Yes, a full stop. The dot stands for localhost. People stare at “Server name” the first time, expecting it to want a full hostname.
Choose Windows Authentication on your own machine and click Connect.
Don’t need Copilot? We’d skip the AI Assistance workload. You can add it later through the Visual Studio Installer, under Modify, without reinstalling SSMS.
Connecting to Azure SQL Database
- Copy the server name. In the Azure portal, open the database and copy “Server name”.
- Open the firewall. On the logical SQL server, not the database, go to Networking and add your current client IP.
- Connect. Paste the server name and choose SQL Server Authentication with the admin login you created. If your organization uses Microsoft Entra, pick one of those options.
- Pick the database. Under Options, Connection Properties, type the database name.
| Detail | Note |
|---|---|
| Server name format | yourserver.database.windows.net |
| Skipping the firewall step | You just get blocked, with an unhelpful message |
| Recent SSMS 22 builds | They can offer to create the firewall rule from the connection dialog once you sign in to Azure |
| Microsoft Entra | The service formerly called Azure AD |
| No database name set | You land in master and wonder where your tables went |
Once connected, Azure SQL feels much like a local server. You browse tables, run queries, manage permissions and export data.
One difference catches people out. Azure SQL Database has no SQL Server Agent.
Scheduled work runs through Elastic Jobs or Azure Automation there. Azure SQL Managed Instance does have Agent.
Features to learn first
We’d learn five features first. Together they cover most daily database work.
Other tools exist: pgAdmin, DBeaver, DataGrip and MySQL Workbench. For SQL Server, we’d say SSMS still covers more ground than any of them.
Object Explorer
The tree on the left. Expand a server, and you see databases.
Expand a database, and you get tables, views, stored procedures, functions and security. Further down sit Agent jobs and linked servers.
It’s the whole server, laid out like folders. Right-click anything for actions.
A daily habit for many DBAs: right-click a table to script it out or check its properties.
You can connect to several servers at once. That’s a handy way to compare objects between development and production.
Query Editor and IntelliSense
Type T-SQL, press F5 and read the results. IntelliSense autocompletes as you type.
It can stall on databases with thousands of objects. Rebuilding its cache usually brings it back.
A favourite habit: select three lines in a long script and run only those. No commenting out needed.
The results grid copies straight into Excel.
Since 22.10.2 the built-in SQL Formatter is generally available too, with options for casing, brackets and line breaks.
SQL Server Agent for job scheduling
Agent is how you automate SQL Server.
- A backup at midnight.
- An index rebuild every Sunday.
- A T-SQL job that loads data at 6 AM before anyone arrives.
SSMS gives you a full GUI to create jobs, set schedules and raise alerts when something fails. And things fail.
When they do, the job history usually tells you which step broke and why. This single feature keeps many DBAs on SSMS.
Execution plans and performance tuning
A query is slow, and you don’t know why. Turn on the actual plan before running it.
SSMS then draws every step SQL Server took: index scans, hash joins, sorts, nested loops. Thicker arrows stand for more rows moving through that step.
The estimated plan shows the same picture without running anything.
A typical case: the plan shows a table scan on a huge table, caused by a missing index. With the index added, a query of many seconds dropped to milliseconds.
That’s the typical payoff.
Activity Monitor
Right-click the server in Object Explorer and choose Activity Monitor for a live view.
It shows processor time, running processes, waits, disk I/O and expensive queries.
We’d open it first whenever a developer writes “the database is slow”. Most of the time one query is hogging everything.
It shows up in the first few seconds.
GitHub Copilot in SSMS 22
Copilot works as an AI assistant built into the editor. It needs the AI Assistance workload and a GitHub account with Copilot access.
A free Copilot tier exists, with monthly limits.
| Part | What it does |
|---|---|
| Ask mode | A chat window for questions and T-SQL generation |
| Agent Mode | Can inspect connected objects and run diagnostic skills |
| Inline completions | Optional suggestions as you type |
| Build | Date | Change |
|---|---|---|
| 22.4.1 | March 18, 2026 | Copilot became generally available |
| 22.5.2 | Not stated | Inline completions are off by default from this build |
| 22.9.0 | Not stated | Ask mode stopped running arbitrary queries on your server |
| 22.10.2 | September 28, 2026 | Agent Mode followed |
In Agent Mode, what Copilot may execute is limited by the permissions of the SQL login you connected with.
We’d use a login with the rights you’d give a junior colleague, not sysadmin.
To switch inline completions on, go to Tools, Options, Text Editor, Inline Suggestions, General. Select the Copilot completions option there.
With them on, you can type a comment and the word SELECT, and Copilot suggests a complete query to review.
-- find top 10 customers by revenue
SELECT
That was on AdventureWorks, the “hello world” of sample databases.
On a production schema with column names like col1_bk_old, it got confused. Multi-table joins often needed fixing by hand.
The chat is useful for chores: “list the 10 largest tables by row count”, or “write a query to find duplicate email addresses”.
It can also reference columns that don’t exist. Read every line before you run it.
A setup trap: if you skip the AI Assistance workload, Copilot simply doesn’t appear. It’s easy to lose time hunting for it before checking the installer.
Which version to use
We’d use SSMS 22, the current version, on any listed Windows 11 or Windows Server 2019+ machine.
Microsoft ships fixes, security updates and features only in the latest release of the latest major version.
So the older lines count as legacy. Upgrade unless you need one for a specific reason.
One common confusion first. SSMS version numbers have nothing to do with SQL Server version numbers.
SSMS 22 isn’t “for SQL Server 2022”. It manages SQL Server 2014 through 2025.
| SSMS version | Shell and installer | Highest SQL Server it manages | Status in 2026 |
|---|---|---|---|
| SSMS 22 | Visual Studio 2026, VS Installer | SQL Server 2025 | Current, 22.11.3 |
| SSMS 21 | Visual Studio 2022, VS Installer, 64-bit | SQL Server 2025 | Superseded; upgrade |
| SSMS 20 | Standalone installer | SQL Server 2022 | Legacy |
| SSMS 19 | Standalone installer | SQL Server 2022 | Legacy |
| SSMS 18 | Standalone installer | SQL Server 2019 | Legacy |
There’s one good reason to keep an old version: the legacy SSIS service.
SSMS connects only to the legacy Integration Services service of its matching SQL Server version. An old SSIS 2019 setup still needs SSMS 18 as well.
Packages in the SSISDB catalog work fine from SSMS 22.
What replaced Azure Data Studio
Azure Data Studio is gone. Microsoft’s replacement for cross-platform work is Visual Studio Code with the MSSQL extension.
It opens existing queries, scripts and database projects without conversion.
The short version we’d give: a DBA on Windows uses SSMS. A developer on a Mac uses VS Code with the MSSQL extension.
Many people use both, SSMS for administration and VS Code for scripts that live in Git.
| Feature | SSMS 22 | VS Code + MSSQL extension |
|---|---|---|
| Platform | Windows only | Windows, macOS, Linux |
| Price | Free | Free |
| SQL Server Agent jobs | Full GUI | Not a focus; use T-SQL |
| Object Explorer | Full tree with every object type | Basic tree |
| Execution plans | Full graphical plans | Plan viewer |
| Activity Monitor, replication, Always On setup | Yes | No |
| Git integration | Yes, from the VS shell | Built in |
| Dark theme | Yes | Yes |
| Best for | DBAs, production administration | Developers, cross-platform scripting |
Reach for SSMS when you need one of these.
- Managing SQL Server Agent jobs, operators and alerts.
- Configuring replication or Always On availability groups.
- Watching Activity Monitor during an incident.
- Scripting out objects or whole databases.
- Working with SSRS, SSIS or maintenance plans.
Alternatives for Mac and Linux
| Tool | Platform | Cost | Best for |
|---|---|---|---|
| VS Code + MSSQL extension | Windows, Mac, Linux | Free | Cross-platform queries, database projects, Git workflows |
| DBeaver | Windows, Mac, Linux | Free Community, paid Pro | Teams that also use PostgreSQL, MySQL or Oracle |
| DataGrip, from JetBrains | Windows, Mac, Linux | Paid subscription | Developers already on JetBrains tools |
| dbForge Studio for SQL Server | Windows | Paid | Schema compare, data generation, advanced editing |
| HeidiSQL | Windows | Free | Lightweight work on MySQL, MariaDB and SQL Server |
On a Mac you can also run Windows 11 on Arm in a virtual machine and put the Arm64 build of SSMS itself on it.
Honestly, none of these replaces SSMS for serious SQL Server administration. No full Agent management, no SSRS, no real Activity Monitor.
For writing queries and browsing data, they do the job.
DBeaver on a MacBook can work against a remote SQL Server 2022 instance. For everyday queries it holds up well enough.
Fixing common SQL Server Management Studio errors
Most errors come from five causes, and each has a quick, known fix.
| Cause | Section |
|---|---|
| The SQL Server service is stopped, or the instance name is wrong | Can’t connect to server |
| Encryption rejects an untrusted certificate | The certificate chain message |
| The installer has no internet access | Setup without internet |
| Too many open tabs, or a stale IntelliSense cache | Slow or frozen |
| A firewall blocks port 1433 | Can’t connect to server |
Can’t connect to server
The first error every newcomer meets. Check these in order.
- The SQL Server service is running. SQL Server Configuration Manager shows it.
- The instance name is right. Named instances use a backslash, and people type a forward slash all the time.
- TCP/IP is enabled for the instance.
- Windows Firewall isn’t blocking TCP port 1433, or UDP 1434 for the Browser service on named instances.
On fresh Windows installs the firewall often is the cause.
The certificate chain message
The full text says the certificate chain was issued by an authority that is not trusted.
Since SSMS 20, connections default to mandatory encryption. Most development servers use a self-signed certificate, so SSMS refuses.
On a development box, tick Trust server certificate in the connection dialog.
On production, put on a proper certificate from a trusted CA. It takes about twenty minutes and removes the warning for everyone.
Setup without internet
The Visual Studio Installer wants the internet. On an air-gapped server, create an offline layout on a connected machine first.
vs_SSMS.exe --layout C:\SSMSOffline
Copy the folder across and run the installer from it.
Microsoft also asks you to put the Visual C++ v14 Redistributable, x86 and x64, on the offline machine beforehand.
Slow or frozen
Usually it’s tabs. Each open query keeps its results in memory, so close the ones you’re done with.
IntelliSense on a database with thousands of objects is the other common cause. Refresh its cache with the shortcut from the table below.
Or turn it off under Tools, Options, Text Editor, Transact-SQL, IntelliSense.
On 4 GB of RAM, expect pain. As a 64-bit app, SSMS 22 will happily use 8 GB or more on large plans.
With 16 GB the difference is clear.
Copilot doesn’t appear
If the Copilot window is missing, the AI Assistance workload is probably not there.
Open the Visual Studio Installer, choose Modify on SSMS 22 and tick it. Then sign in with a GitHub account that has Copilot access.
SQL Server Management Studio silent install from the command line
Ten workstations, no clicking. The same vs_SSMS.exe takes parameters, from an elevated prompt.
Minimal install, no prompts, progress shown:
vs_SSMS.exe --installPath C:\SSMS22 --passive --norestart
Fully silent, waits until it’s done:
vs_SSMS.exe --installPath C:\SSMS22 --quiet --wait
With a workload, here the Business Intelligence one:
vs_SSMS.exe --add Microsoft.SqlServer.Workload.SSMS.BI --includeRecommended --passive --norestart
| Switch | What it does |
|---|---|
--passive |
Shows progress, asks nothing |
--quiet |
Shows nothing at all |
--wait |
Returns only when setup has finished, handy in scripts |
--installPath |
The target folder, chosen once at first install |
--add |
A workload or component ID |
--locale en-US |
Forces the installer language |
Need a specific older build instead? Microsoft keeps the installers for past versions on its SSMS release history page. That’s also where versions for SQL Server older than 2014 live.
Uninstall SQL Server Management Studio
Usually through Settings, Apps, or the Visual Studio Installer, where SSMS 22 has its own More menu with Uninstall.
From the command line it’s two steps. The installer folder first:
cd "C:\Program Files (x86)\Microsoft Visual Studio\Installer"
Then the removal itself:
setup.exe uninstall --passive --productId Microsoft.VisualStudio.Product.Ssms --channelId SSMS.22.SSMS.Release --noweb
Databases stay where they are. SSMS is only the client, so removing it doesn’t touch a single SQL Server instance or its data. Need an engine license for that server? Our SQL Server keys cover 2012 through 2022.
Updating SQL Server Management Studio
SSMS must be closed while the update runs.
| Route | How |
|---|---|
| Inside SSMS | Help, Check for Updates, or the notification bell in the lower-right corner; then Update or Update on Close |
| Visual Studio Installer | Open it from the Start menu and click Update next to SSMS 22 |
| Automatic | Tools, Options, Environment, Product Updates, then “Always update on close” |
| Command line | The two lines below; the second is for offline layouts |
vs_SSMS.exe update --quiet
vs_SSMS.exe update --quiet --noWeb
We’d take updates as they come. Not mainly for features: connection bugs, IntelliSense crashes and security issues get fixed in point releases.
The October 2026 builds alone fixed an Extended Events file-naming bug and a Copilot model error.
SQL Server Management Studio keyboard shortcuts
Learn these ten, and you’ll rarely touch the mouse.
| Shortcut | What it does |
|---|---|
| F5 | Execute the query or the selected text |
| Ctrl+R | Show or hide the results pane |
| Ctrl+Shift+U / Ctrl+Shift+L | Uppercase or lowercase the selection |
| Ctrl+K, Ctrl+C | Comment out selected lines |
| Ctrl+K, Ctrl+U | Uncomment selected lines |
| Alt+F1 | Run sp_help on the selected object: columns, indexes, constraints |
| Ctrl+J | Force the IntelliSense list to appear |
| Ctrl+Shift+R | Refresh the IntelliSense cache |
| Ctrl+L | Display the estimated execution plan without running |
| Ctrl+M | Include the actual execution plan in the results |
Two more habits. Drag table names from Object Explorer into the editor, and don’t type them.
If you keep twenty query windows open, try vertical tabs under Tools, Options, Environment, Tabs and Windows. It’s a big change for a crowded editor.
SQL Server Management Studio licensing
SSMS is free and needs no license of its own, for personal or commercial use. What needs a license is the SQL Server instance you connect to.
| SQL Server edition | License |
|---|---|
| Express | Free, within its size limits |
| Developer | Free, with the full feature set; for non-production only |
| Standard and Enterprise, in production | Paid licenses for the server and, depending on the licensing model, CALs |
To learn or build, we’d take SQL Server Developer edition. It’s free from Microsoft, but may not run production workloads.
For production on a budget, Express works within its limits.
Those limits, edition by edition, are in SQL Server 2022 Standard vs Enterprise vs Express.
Production licensing is where cost appears. For many small and mid-size businesses, SQL Server Standard on a current Windows Server is the usual setup.
Our SQL Server license category lists the versions we carry.
Need a key? Our SQL Server 2022 Standard key comes as a genuine license. Delivery is instant to email.
Windows Server versions for SQL Server Management Studio
SSMS 22 goes on Windows Server 2019 and later, Standard and Datacenter. The Minimal Server Interface option isn’t on Microsoft’s list.
From those machines, or from a Windows 11 workstation, it manages SQL Server on other hosts too. The SQL Server version has to be 2014 or later.
In practice we’d put SSMS on a workstation and connect remotely, not on every server. Fewer installs to patch, and less load on production.
Old servers are worth a look while you’re at it. See our Windows Server 2016 guide.
Unsure if you need Server at all? Our explainer on Windows vs Windows Server covers the differences.
Active Directory, failover clustering and much higher memory limits are why production SQL Server lives on Server.
Common SQL Server Management Studio mistakes
- Reading “SSMS 22” as “for SQL Server 2022”.
- Downloading from a mirror site.
- Typing a forward slash in a named instance.
- Forgetting the Azure firewall rule and blaming the password.
- Leaving the database name empty for Azure SQL and landing in master.
- Skipping the AI Assistance workload and then hunting for Copilot.
- Giving Copilot’s Agent Mode a sysadmin login.
- Keeping fifty result tabs open and wondering about memory.
Related guides
Terms used on this page
| Term | Meaning |
|---|---|
| SSMS | The management tool this page is about |
| T-SQL | Transact-SQL, Microsoft’s dialect of SQL |
| Instance | One running copy of SQL Server; a machine can host several |
| Object Explorer | The tree of servers, databases and objects |
| SQL Server Agent | The job scheduler of SQL Server |
| Execution plan | The steps the engine takes to run a query |
| IntelliSense | Autocomplete in the query editor |
| Workload | An optional component set in the Visual Studio Installer |
| Microsoft Entra | Microsoft’s identity service, formerly Azure AD |
| SSIS and SSRS | Integration Services and Reporting Services |
| CAL | Client access license |
Typical SSMS connection and setup problems
A typo in the local computer name
A misspelled machine name and the dialog just times out. A single dot as the server name reaches the local instance at once. No typing, no typos.
A named instance typed with a forward slash
Fails every time. SQL Server wants a backslash between machine and instance. Like this:
.\SQLEXPRESS
An untrusted certificate on an old development server
Encryption is mandatory by default since SSMS 20, and a self-signed certificate doesn’t pass. On a development box, tick Trust server certificate. On production, a proper certificate.
Azure SQL blocked from a home connection
The client IP isn’t in the server’s firewall rules. Add it under Networking on the logical server, then the same login works.
No Copilot window after setup
The AI Assistance workload was skipped. Visual Studio Installer, Modify, tick it. No reinstall needed.
SSMS 22 on a Windows 10 workstation
Windows 10 isn’t on Microsoft’s list for SSMS 22. An older SSMS stays on that PC until it moves to Windows 11.
Setup on a server with no internet
The installer needs the web. Build an offline layout on a connected PC, copy the folder across, install from it.
The legacy SSIS service of SQL Server 2019
SSMS 22 can’t reach it. That service talks only to its matching SSMS, so version 18 stays installed next to 22.
A slow editor on a large database
IntelliSense crawls with thousands of objects. Refresh its cache. Close a pile of old result tabs as well.
SSMS versions and systems this guide covers
| Item | Details |
|---|---|
| SSMS 22.x on Windows 11 | x64 and Arm64, 24H2 and 25H2 |
| SSMS 22.x on Windows Server | 2019, 2022 and 2025 with Desktop Experience |
| Connections | SQL Server 2019, 2022 and 2025 instances, and Azure SQL Database |
FAQ
Is SQL Server Management Studio free?
Yes, completely. SSMS has no trial, no paid edition and no license requirement, for personal or commercial use. Only the SQL Server instance you connect to may need a license.
What is the difference between SQL Server and SQL Server Management Studio?
SQL Server is the database engine that stores data and runs queries. SSMS is the application you use to talk to that engine. We'd put SSMS on a workstation and manage SQL Server on another machine from there.
Can I use SQL Server Management Studio on a Mac?
Not natively, since SSMS runs on Windows only. On a Mac, we'd use Visual Studio Code with the MSSQL extension, DBeaver or DataGrip. Windows 11 on Arm in a virtual machine can run the Arm64 build too.
What is the latest version of SSMS?
SSMS 22. The latest build as of November 2026 is 22.11.3, released October 29, 2026. SSMS 22 first shipped on November 11, 2025.
Does SSMS 22 run on Windows 10?
Windows 10 isn't on Microsoft's list for SSMS 22. The list has 64-bit Windows 11, x64 and Arm64, and Windows Server 2019 and later.
Do I need Visual Studio installed to use SSMS?
No. SSMS uses the Visual Studio Installer and shell, but it stands alone. You don't need Visual Studio Community, Professional or Enterprise.
Which SQL Server versions can SSMS 22 manage?
SQL Server 2014 and later, up to SQL Server 2025. It also manages the Azure SQL services, Azure Synapse Analytics and SQL databases in Microsoft Fabric.
How do I turn on GitHub Copilot in SSMS?
Add the AI Assistance workload in the Visual Studio Installer and sign in with a GitHub account that has Copilot access. Then open the Copilot chat. Inline completions are off by default, and we'd enable them under Tools, Options, Text Editor.
