Sample Header Ad - 728x90

SSMS21 on windows 2022 server opens a new instance every time I double click a sql file

1 vote
2 answers
521 views
When I installed SSMS21 on windows 2022 server I noticed the extremely disruptive new feature where it will not use the open and logged in instance of SSMS when I double click a .sql file. Instead, it opens a new instance is SSMS, taking forever and eating resources. I tried lots of registry hacks posted here and there on the internet, and even enlisted the help of chatgpt and copilot to try to fix it. No success. Imagine my surprise when Brent sent me this link https://14days.brentozar.com/ssms.mp4 showing him double clicking on a sql file and it using the open instance of SSMS 21! According to Brent, the only difference here is he is using Windows 2025. Unfortunately, I do not have access to windows 2025 yet. I build a clean VM with the following specs: Windows Server 2022 Standard 21H2 OS Build 20348.3807 SSMS SQL Server Management Studio 21.3.7+3.36221.1 I launch SSMS and log in to the database. Then I use windows explorer to find my sql files and double click on one. A brand new instance is SSMS slowly launches! Grrrr! I know it can work because I see Brent's video. Anyone know the magic sauce to make it work for me?
Asked by davethegeek (21 rep)
Jul 1, 2025, 10:45 PM
Last activity: Jul 3, 2025, 03:47 PM