How can we help you today? How can we help you today?

SSMS22 & SQL Prompt 11 crash after latest SSMS22 update (10-02-2026)

I updated SSMS 22 to latest release (10th feb 2026), and now it crashes consistantly if SQL Prompt 11(latest version) is also installed.
I had to remove SQL Prompt to get SSMS 22 to stop crashing.
I have tried to do complete uninstall of both SSMS 22 & SQL prompt 11, but with same result

Bjørn
62

Comments

77 comments

  • Evert

    Same here, crash occurs after connecting to a database server.

    Evert
    12
  • Bjoern

    The error message complained about a missing assembly refference. Mainly Microsoft.SqlServer.ConnectionInfo.dll

    I went into "C:\Windows\assembly\GAC_MSIL\Microsoft.SqlServer.ConnectionInfo\13.0.0.0__89845dcd8080cc91\Microsoft.SqlServer.ConnectionInfo.dll" and copied the file.

    In the filepath you might have another number than me “13.0.0.0__89845dcd8080cc91”, but that doesnt matter.

    Then i pasted it into "C:\Program Files (x86)\Red Gate\SQL Prompt 11\Microsoft.SqlServer.ConnectionInfo.dll"

    Now it works since SQL Prompt finds the library. I can connect to my servers again without SSMS 22.3 crashing

    Bjoern
    11
  • Simon Train

    Latest SSMS 22.3.0 update changed the Microsoft.SqlServer.RegSvrEnum assembly version from 17.100.0.0 to 17.100.40.0. This breaks SQL Prompt's reference.

    Simon Train
    6
  • Dani Sardà

    Same problem. 

    I had to revert to SSMS 22.2.1.

    SSMS 22.3 only works if SQL Prompt is not installed. SQL Search can be installed (it does not cause SSMS to crash), but the button does not appear.

    Dani Sardà
    5
  • timothy.batts

    Check the documentation in the Release Notes for the fix: SQL Prompt Compatibility Update for SSMS 22.3 - SQL Prompt 11 - Product Documentation. The below tools are not currently compatible with SSMS 22.3, and need to be uninstalled, as they will still cause SSMS 22.3 crash even with the SQL Prompt fix: 

    • SQL Dependency Tracker
    • SQL Data Generator
    • SQL Doc
    • SQL Search
    • SQL Test
    timothy.batts
    5
  • Zach

    Same here with SSMS 22.3.0 and latest SQL Search 3.9.

    Reverting back to SSMS 22.2.1 solved the issue.

    Awaiting SQL Search update

    Zach
    4
  • Robert MacQueen

    Microsoft notes that there is a breaking change in this release for Extensions.  See https://techcommunity.microsoft.com/blog/sqlserver/announcing-database-instructions-and-a-lot-of-fixes-in-sql-server-management-stu/4494468

    “In this release we also updated to later releases of Microsoft.Data.SqlClient (MDS) and SQL Management Objects (SMO).  While these updates are invisible and foundational to core SSMS functionality, they are quite impactful to components like third-party extensions that have dependencies on them.  We are aware that SSMS 22.3 does not work when certain third-party extensions are installed, and we are following up with extension owners based on feedback items that have already been opened. If you use a third-party extension, be aware this could happen. If you uninstall the third-party extension and the problem no longer occurs in SSMS 22.3, please file a ticket with the extension owner.  ”

    Robert MacQueen
    4
  • Bo Ngoh

    I got hit as well. I found that keeping SSMS but uninstalling then installing the previous version here works:

    https://download.red-gate.com/checkforupdates/SQLPrompt/SQLPrompt_11.3.4.20814.exe

    Bo Ngoh
    4
  • Simon Train

    Same solution for me. Had to revert to SSMS 22.2.1. Lost all my open query windows!

    Simon Train
    3
  • Stefan

    Same issue, following for a fix, thank you.

    Stefan
    3
  • Tom

    The Visual Studio Installer lets you rollback to a previous version of SSMS.  It's under the “More" dropdown.  It's how I got back to 22.2.1.

    Tom
    3
  • SelectStar

    Same here.  Redgate, please fix ASAP.  

    Don't you get early releases from Microsoft so these kinds of things can be avoided?

    SelectStar
    3
  • James W

    I can get 22.3 to work by:

    • running as administrator
    • not connecting to the Object Explorer to the server.

    When it opens, cancel the initial connection. From there, only connect queries to the server.
    It's a half-rate workaround, but it's potentially helpful for the moment.

    James W
    3
  • CR12

    same heree!

    CR12
    2
  • Greg Cheves

    I have this same issue and uninstalling SQL Prompt was the only way to resolve it as of now.

    Greg Cheves
    2
  • Robert MacQueen

    Same here.  Going back to the previous version of SSMS resolved the problem.

    Robert MacQueen
    2
  • jrozzi

    We're having the same problem as well. 

    SSMS 22.3.0 crashes with the current latest versions of Redgate SQL Prompt 11.3 / SQL Source Control 8.1 / SQL Search 3.9 / SSMS Integration Pack 3.2. 

    Downgrading SSMS to version 22.1.0 resolves the issue for now.

    Hope to see a fix from Redgate soon.

    jrozzi
    2
  • Robert MacQueen

    Adam, yes I had to uninstall 22.3.  I did not have in install of 22.2.1, and the only one I could find @ microsoft was the evergreen build of 22 which is 22.1.0 released in December 2025 - see https://learn.microsoft.com/en-us/ssms/release-history.  If anyone can point to the install for 22.2.1 I would love to know.

    Robert MacQueen
    2
  • Tony

    Same issue with SQL Search.  SSMS 22.3 crashes immediately after touching anything.  Uninstalling SQL Search fixed the SSMS crashing.

    Tony
    2
  • Ivan

    Same..

    Ivan
    2
  • Brian

    Same issue here. I was unable to rollback to 22.2.1 in the VS installer.

    Had to uninstall SQL Prompt as well as SQL Search just for SSMS 22.3 to not crash/restart.

    I can't find an installation of SSMS 22.2.1, so I'm having to use my old SSMS 21.6.17 - which still works with the SQL Prompt and SQL Search at least.

    Brian
    2
  • Evert

    FYI: 
    Redgate Support answered me on Feb 11, 2026, 16:51 GMT:

    "Yes we are aware of this issue with SSMS 22, SQL Search and SQL Prompt. The development team are testing a fix as we speak. All being well it shall be deployed very soon."

    So let's wait and see...

    Evert
    2
  • Christian

    @Rene In Visual Studio Installer, section “SQL Server Management Studio 22” you might have a “Rollback” entry in the options. Worked well for me.

    Christian
    2
  • fernandog

    Hi!, some error here installing SQL Search 3.9.4 with SSMS 22.3…

    Only uninstalling SQL Search solve the problem.

    In “sqlsearchlog-*.log” i can see these relevant info:

    [Error]  [RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer]: Unable to find all needed assemblies

     

    Thank you!

    fernandog
    2
  • Ian Keogh

    They just released an update to fix the issue, version 11.3.6.21421

    https://download.red-gate.com/checkforupdates/SQLPrompt/SQLPrompt_11.3.6.21421.exe

    "Fixed an incompatibility between SQL Prompt and SSMS 22.3 which caused SSMS to consistently crash when SQL Prompt was installed"

    SQL Prompt 11.3 release notes - SQL Prompt 11 - Product Documentation

    Ian Keogh
    2
  • John

    I posted this over on sql server central…

    After multiple reverts, re-dos and uninstall / re-installs, this is where I'm at.

    Uninstalled SQL Prompt, SQL Search, SQL Source Control.

    Uninstalled SQL 22.2.0 fully, rebooted. Upgrading/downgrading never fixed underlying problems.

    Installed SQL 22.3.0 vanilla. Launched, it worked fine.

    Installed SQL Prompt 11.3.6.21421, launched, working fine.

    Installed SQL Search 3.9.4.6402, launched, BOMB. Uninstalled SQL Search, launched, all back to being OK. So SQL Search is a no-go for now.

    Installed SQL Source Control 8.1.6.23205, launched, working fine.

    But, then SQL Prompt was missing from the toolbar. I went into Extensions and unchecked the oddly double entries of SQL Prompt, and it restarted. After SSMS restart, the menu is there again and things are working (so far).

    The key overall was to uninstall SSMS completely; doing downgrades and upgrades never fixed the underlying issue. Then, I was able to isolate SQL Search as my particular issue.

    John
    2
  • George Hendrickson

    After installing the latest update to SQL Prompt (11.3.6), which was supposed to resolve the crashing issue, SSMS 22.3 is still crashing.

    I completely uninstalled SQL Prompt and SQL Search, upgraded SSMS to 22.3, and then reinstalled both extensions. When I launched SSMS and connected to my database, it crashed again.

    Next, I opened Visual Studio and updated SQL Prompt and SQL Search to the latest available versions. However, after reopening SSMS and connecting to the same database, it crashed once more.

    George Hendrickson
    2
  • George Hendrickson

    **UPDATE**
    Turns out, SQL Search is the culprit now. If you also use SQL Search, it will crash SSMS 22.3 …

    George Hendrickson
    2
  • Simon Train

    Same issue for me. Tried closing SSMS 22, uninstalling SQL Prompt and re-installing latest version of SQL Prompt. SSMS 22 crashes as soon as I connect to registered server.

    Error in ..\AppData\Local\Red Gate\Logs\SQL Prompt 11 log file says
    [Outer exception] System.IO.FileNotFoundException : Could not load file or assembly 'Microsoft.SqlServer.RegSvrEnum, Version=17.100.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.
      at RedGate.SqlPrompt.Shell.ConnectionInfoRetriever.GetConnectionFromDocView(Object view)
      at RedGate.SqlPrompt.Shell.ConnectionInfoRetriever.GetConnectionInfo(ITextViewWrapper textViewWrapper)
    29028 2026-02-11 10:38:56.560 +00:00 [Warning] Error getting connection info

    Simon Train
    1
  • Bryant McClellan

    Same issue but without installing SQL Prompt. SSMS starts but crashes upon connecting to a server.

    Bryant McClellan
    1

Add comment

Please sign in to leave a comment.