SQL Search fails to start in VS 2022

plamen

Hi,
SQL Search is failing to start in VS 2022. When I start it I'm getting the following error:
The VsPackage package didn't load correctly.

Those are the details from the ActivityLog.xml file:

SetSite failed for package [VsPackage]Source: 'RedGate.SQLSearch.Shell.18' Description: Object reference not set to an instance of an object. System.NullReferenceException: Object reference not set to an instance of an object. at RedGate.SQLSearch.Shell.VS.SsdtObjectExplorerConnectionWatcher..ctor(ILog logger) at RedGate.SQLSearch.Shell.VS.SsmsFunctionalityProvider..ctor(DTE2 dte2, SsmsFunctionalityPackage package, Type toolWindowType, ILog logger) at RedGate.SQLSearch.VSExtension.VsPackage.<InitializeAsync>d__3.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at Microsoft.VisualStudio.Shell.AsyncPackage.<>c__DisplayClass20_0.<<Microsoft-VisualStudio-Shell-Interop-IAsyncLoadablePackageInitialize-Initialize>b__1>d.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at Microsoft.VisualStudio.Services.VsTask.RethrowException(AggregateException e) at Microsoft.VisualStudio.Services.VsTask.InternalGetResult(Boolean ignoreUIThreadCheck)

Kurt_M

Hi @plamen,

Please can you try and uninstall the extension through Extensions > Manage Extensions. After this, restart VS 2022 and then try and re-install the extension once more through that same menu.

You may also wish to try uninstalling SQL Search from the control panel as well, to completely remove it from your system. After this, you can try re-installing. Below is the latest download link:

https://download.red-gate.com/checkforupdates/SQLSearch/SQLSearch_3.6.0.3167.exe