SQL Server Management Studio is still the tool most production DBAs live in day to day, and it has changed more in the last couple of years than the previous decade. There is a new install and update model, a different default connection security posture, and enough quality-of-life settings buried in menus that most people never find them.
This page collects the SSMS setup, scripted-install, and troubleshooting posts on this site, plus the settings and shortcuts that never earned their own post but are worth knowing anyway, organized by what you’re actually trying to do: get it installed, configure it the way you want, or fix the thing that just broke.
Installation & Maintenance
The manual walkthrough for a one-off install on your own workstation, or the scripted version below when you’re setting up more than one machine.
Silent by default, detects which installer framework is already on the box, and adds SSMS to PATH when it’s done. Built for fleet installs and repeat jump-host setups, not a one-off click-through.
Troubleshooting & Configuration
Which One You Need
- Fresh machine or SSMS won’t update: start with Install & Update, or the scripted version if you’re setting up more than one box.
- Suddenly can’t connect after an SSMS upgrade: it’s almost always the certificate chain trust error.
- Need to test as another account: Open as a Different Domain User.
- A query’s output looks cut off, or you can’t see something you expect in Results to Text: the 256-character limit.
Keyboard Shortcuts Worth Knowing
The handful that save real time every single session, not the exhaustive list:
| Shortcut | What it does |
|---|---|
F5 |
F5, Ctrl+E, and Alt+X all execute. Alt+X is the one I use. |
Ctrl+R |
Toggle the Results pane, useful to reclaim screen space while writing a long query |
Alt+F1 |
Run sp_help against whatever object name the cursor is sitting on |
Ctrl+K, Ctrl+C |
Comment out the selected lines |
Ctrl+K, Ctrl+U |
Uncomment the selected lines |
Ctrl+Shift+U / Ctrl+Shift+L |
Uppercase / lowercase the selected text, handy for normalizing keyword casing |
Shift+Alt+Arrow |
Column (box) selection, select a vertical block instead of full lines, useful for editing a list of similar values in place |
Ctrl+Shift+R |
Refresh the IntelliSense local cache, the fix when IntelliSense is showing objects that no longer exist or missing ones that do |
Frequently Asked Questions
Is SSMS still being actively updated?
Yes. It ships as a separate download from the SQL Server engine now, with its own release cadence, roughly every few months. See Install & Update above for where to get it and how the update checks work.
What replaced Azure Data Studio?
Visual Studio Code with the MSSQL extension. Azure Data Studio was retired on 28 February 2026 and no longer gets updates or security fixes, and Microsoft’s guidance is to move to VS Code, where existing queries, scripts and database projects open without conversion. For production DBA work it still isn’t an SSMS replacement: the object-level dialogs, SQL Server Agent management and the Maintenance Plan designer are only in SSMS.
Why does SSMS suddenly refuse to connect after an update?
Almost always the certificate chain trust error, current SSMS versions default to encrypting the connection and validating the server’s certificate, which older instances running a self-signed cert weren’t set up to satisfy. See Fix the Certificate Chain Trust Error above for the actual cause and fix.
Can I install or remove SSMS across several machines without clicking through each one?
Yes, see the scripted Install & Update and Uninstall links above. Both are silent by default, log what they did, and are built for fleet or repeat jump-host setups rather than a single interactive install.
Can I run SSMS on Linux or macOS?
No, SSMS itself is Windows-only. From Linux or macOS the supported option is now Visual Studio Code with the MSSQL extension, since Azure Data Studio was retired in February 2026, or a plain sqlcmd session for anything scriptable.
Where To Go Next
SSMS set up and behaving is the starting line, not the finish. Three directions from here, depending on what today actually is:
F5 runs it, Ctrl+R reclaims the screen, and Ctrl+Shift+R fixes IntelliSense when it lies to you. Jump back up for the full table.
Leave a Reply