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

Recent upgrade of SQL Search to 3.0 causes package to not load correctly in SMSS 22

I am running SQL Server Management Studio 22.3.0+24.11505.172.

I have been using SQL Prompt, SQL Compare, and SQL Search for years…keeping all tools as their updates are released.

My latest up of SQL Search (to 3.9) caused this message whenever I ran SMSS.   

After a few second SMSS would close.

I have tried uninstalling just SQL Search and reinstall.  Same result.

I have tried uninstalling all Red Gate tools and reinstall. Same result.

I have tried uninstalling all Red Gate tools, run the \updateconfig Command Prompt "start /wait "" "./SSMS.exe" /updateconfiguration", deleted the entire RED Gate programs folder, then reinstall the three tools, Same Result.

Right now i have stopped using RedGate…. it's the only way for SMSS 22 to remain running.

keith bergoch
9

Comments

23 comments

  • keith bergoch

    correction….  Sql Search 3.9

    keith bergoch
    1
  • Glenn

    Same issue experienced.  Uninstalled all Red Gate tools from Windows App installer.  Deleted all Red Gate Folders.  Restarted computer.  Launched SSMS 22.3 to make sure that the version is stable - it was ok. Closed SSMS.

    Reinstalled Red Gate from latest install package. Launched SSMS again.  Issue has not happened again (yet!)

    Glenn
    2
  • Tony Nancarrow

    Please read this article for information of incompatibility issues between Redgate utilities and SSMS 22.3.
    Compatibility issues with SSMS 22.3

    Tony Nancarrow
    0
  • Piotr

    Stack trace of the exception after SSMS 22 closed:

    Application: SSMS.exe
    Framework Version: v4.0.30319
    Description: The process was terminated due to an unhandled exception.
    Exception Info: System.IO.FileNotFoundException
      at RedGate.SQLSearch.Shell.VersionSpecific.ShellSpecificConnectionWatcher.ConvertServerNode(Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.INodeInformation)
      at RedGate.SQLSearch.Shell.VersionSpecific.ShellSpecificConnectionWatcher+<get_ServerNodes>d__8.MoveNext()
      at System.Linq.Enumerable+WhereSelectEnumerableIterator`2[[System.__Canon, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089],[System.__Canon, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]].MoveNext()
      at System.Collections.Generic.List`1[[System.__Canon, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]]..ctor(System.Collections.Generic.IEnumerable`1<System.__Canon>)
      at System.Linq.Enumerable.ToList[[System.__Canon, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]](System.Collections.Generic.IEnumerable`1<System.__Canon>)
      at RedGate.SQLSearch.Shell.VersionSpecific.ShellSpecificConnectionWatcher.HaveServerConnectionsChanged()
      at RedGate.SQLSearch.Shell.VersionSpecific.ShellSpecificConnectionWatcher.OnObjectExplorerContextChanged(System.Object, Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NodesChangedEventArgs)

    Exception Info: System.Reflection.TargetInvocationException
      at System.RuntimeMethodHandle.InvokeMethod(System.Object, System.Object[], System.Signature, Boolean)
      at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(System.Object, System.Object[], System.Object[])
      at System.Delegate.DynamicInvokeImpl(System.Object[])
      at Microsoft.SqlServer.Management.SqlStudio.Explorer.BufferedNotification.Fire()
      at System.Threading.ExecutionContext.RunInternal(System.Threading.ExecutionContext, System.Threading.ContextCallback, System.Object, Boolean)
      at System.Threading.ExecutionContext.Run(System.Threading.ExecutionContext, System.Threading.ContextCallback, System.Object, Boolean)
      at System.Threading.NetCore.TimerQueueTimer.CallCallback()
      at System.Threading.NetCore.TimerQueueTimer.Fire()
      at System.Threading.NetCore.TimerQueue.FireNextTimers()
      at System.Threading.TimerQueue.AppDomainTimerCallback(Int32)
     

    Piotr
    0
  • Misa

    I have the same problem. Even deleting all Red Gate folders did not help.

    ---------------------------
    Microsoft SQL Server Management Studio
    ---------------------------
    The 'SqlSearchSsmsPackage' package did not load correctly.

    The problem may have been caused by a configuration change or by the installation of another extension. You can get more information by examining the file 'C:\Users\adminmp\AppData\Roaming\Microsoft\SSMS\22.0_64d2bdc4\ActivityLog.xml'.

    Restarting Visual Studio could help resolve this issue.

    Continue to show this error message?
    ---------------------------
    Yes   No   
    ---------------------------
     

    Misa
    1
  • Reijer

    I also have the same problem. 
    Even reinstalling ssms did not fix it.

    Reijer
    1
  • Tony Nancarrow

    Redgate have just released an update to SQL Prompt (11.3.6) that is compatible with SSMS 22.3.
    Unfortunately SQL Search and some other utilities are still incompatible with SSMS 22.3.
    See SQL Prompt compatibility update for SSMS 22.3.
    I suggest holding off upgrading to SSMS 22.3 until Redgate release compatibility updates for all of the utilities mentioned in the linked article above.

    Tony Nancarrow
    0
  • Connor O'Shea

    I have the same problem

    Connor O'Shea
    0
  • Ian

    I have exactly the same issue. This is really poor. Are these things not tested with the latest version of SSMS? 

    Ian
    1
  • shannon.tarman

    Same issue here

    shannon.tarman
    0
  • dchianura

    same issues with the latest update (18.02)

    dchianura
    1
  • Jon Holden

    Seems to still be broken. I updated SSMS because the latest installer required it - just to find out that it crashes SSMS. 

    I'm rolling back SSMS now and I'll install the older version of the SQL Toolbelt

     

    Jon Holden
    0
  • Ian Keogh

    Per the email that was sent out “Interim fixes for other affected Productivity tools are coming on Wednesday” well today is Thursday and no update for SQLSearch. Do you have an ETA on a fix?

    Ian Keogh
    1
  • Edhy

    Where can I download SQL Prompt version 11.3.5?

    The SQLToolbeltEssentials.exe in my license folder points to version 3.5.3.3038 which contains SQL Prompt version 11.3.6.

    Basically, I need to download the versions of SQL Prompt and SQL Search that will work with SSMS 22.2.1.

    Thanks!

    Edhy
    0
  • Ian Keogh

    Oh I see an update (Version 3.9.5.6487) was just pushed out 😊

    download.red-gate.com

    Installed and working on with SSMS 22.3 woohoo 😊

    Ian Keogh
    3
  • Kenny

    Thank you for the update, problem that we all occurred, is during the installer said hey upgrade to SSMS 22.3 so we did, then SQL search was broken, then broke the other SSMS installs. Leaving everyone broken for entire 2 days before this hotfix. Please do better QA testing this one should have been caught and not released. I hope employees are not vibe coding this tool like Microsoft vibe coding it's updates.

    Kenny
    0
  • Bryant McClellan

    I just installed the new version of SQLSearch. SSMS no longer crashes connecting to a server. However, SQLSearch does not function and still throws an exception on startup.

    Bryant McClellan
    0
  • Edhy

    Thanks to Ian Keogh for posting the link to download individual updates.

    I upgraded SSMS to version 22.3.0, then installed SQLPrompt_11.3.6.21421.exe and SQLSearch_3.9.5.6487.exe.

    I opened SSMS and got not error, then try SQL Prompt and Search tools and they are working as expected.

    Many thanks to the team for rushing to fix this issue. Yes, it took longer than anybody expected but today I am so happy I can use both tools again.

    Edhy
    0
  • Misa

    I confirm that it works for me too. Thanks for your help.

    Misa
    0
  • Ian

    So where can we get SQLSearch_3.9.5.6487.exe
    It's really not entirely obvious. 

    Ian
    0
  • oliviagardner

    This looks like a specific metadata conflict within the SSMS 22.3 extension manager. When SQL Search 3.9 attempts to hook into the updated Object Explorer, any orphaned registry keys from the previous build can trigger a fatal crash, even if the "Program Files" folder is deleted.

    I’ve been analyzing the Interface Reliability of high-performance digital hubs like Royale Aesthetics and Beauty as a benchmark for this. In the high-stakes Med Spa sector, 'Digital Engineering' has shifted toward ‘Zero-Latency Connectivity’ ensuring that the front-end UI and the back-end booking protocols stay in a perfect, synchronized handshake. Their platform is a masterclass in using a clean, medical-grade hierarchy to eliminate the kind of 'Technical Friction' or "System Noise" that causes application crashes during heavy load. By prioritizing a stable, mobile-first journey, they prove that 'Professional Calm' is only possible when the underlying system—whether a SQL extension or a clinical portal is 100% predictable.

    Technical Suggestion:
    Before re-enabling RedGate, try clearing the Component Model Cache for SSMS. You can usually find it at:
    %AppData%\Microsoft\AppEnv\15.0\ComponentModelCache
    Deleting this folder forces SSMS to rebuild its extension index, which often clears the "Package not loading correctly" error that persists after a standard reinstall.

    Do you think the move toward 64-bit architecture in the latest SSMS builds is making these legacy SQL tool integrations more prone to memory-addressing conflicts in 2026?

    oliviagardner
    0
  • Ian

    Trying to get the recommended version SQLSearch_3.9.5.6487.exe. 

    Downloading from this site - SQLSearchDownload.exe is version 3.9.3.3.38 so that is not very helpful. 

    So where / how can I get SQLSearch_3.9.5.6487.exe please? 

    Ian
    0
  • Oleksii.Puzyrenko

    I had the same issue.
    After installing the latest SQL Prompt and SQL Search  , the error disappeared, but SQL Search is not shown anywhere in the SSMS menus or toolbars.

    Oleksii.Puzyrenko
    0

Add comment

Please sign in to leave a comment.