SQL Search does not start in SSMS 18.5

Win32nipuh

I have updated SSMS to v18.5 and then uninstall SQL Search, downloaded the latest one and installed. 
SSMS started, I click button "SQL Search" - no any errors/exceptions but SQL Search does not start.
I have repeated these actions on 2 workstations W7 and W10. The same result.
How to fix it?

etwty

Same problem

razman52

Sql Search opens the tab, but everything is greyed out. I would love to get an answer as I use it ALL the time.

razman52

In reading previous posts I have found a work around. Allow SSMS to startup, open the sql search tab, Open a new connection to a database from the "Object Explorer" window. This gets it functioning.

shang

I have the same problem.  None of the work arounds work for me including uninstalling SQL Search and reinstalling the latest version.

Umair

I installed version 3.5 and that works fine, downloaded it from here: https://download.red-gate.com/checkforupdates/SQLSearch/SQLSearch_3.5.0.2590.exe

mattybrown

Umair said:

I installed version 3.5 and that works fine, downloaded it from here: https://download.red-gate.com/checkforupdates/SQLSearch/SQLSearch_3.5.0.2590.exe

Thanks @Umair, that new version fixes it!  Before I came across your link, I filled out the forms to download a fresh copy from the Red Gate website, but the version that downloads is 3.4.1.2506.  I guess that since 3.4.1.2506 doesn't work in SSMS 18.5, it won't automatically update itself.

Victoria W

Hi all

Following last weeks compatibility issue with SSMS 18.5 the latest versions of all tools are now compatible. These releases have not yet been deployed to the bundle installers but will be soon. Instead, please use the below links to update your SSMS add-in tools.

SQL Prompt, SQL Search and SQL Source Control:
https://download.red-gate.com/checkforupdates/SQLPrompt/SQLPrompt_10.1.4.14671.exe
https://download.red-gate.com/checkforupdates/SQLSearch/SQLSearch_3.5.0.2590.exe
https://download.red-gate.com/checkforupdates/SQLSourceControl/SQLSourceControl_7.1.19.10595.exe

SQL Test, SQL Dependency Tracker, SQL Doc and SQL Data Generator:
https://download.red-gate.com/checkforupdates/SQLTest/SQLTest_4.1.0.994.exe
https://download.red-gate.com/checkforupdates/SQLDependencyTracker/SQLDependencyTracker_3.3.0.1829.exe
https://download.red-gate.com/checkforupdates/SQLDoc/SQLDoc_5.1.0.2241.exe
https://download.red-gate.com/checkforupdates/SQLDataGenerator/SQLDataGenerator_4.4.0.2241.exe

Win32nipuh

Thanx Victoria, and waiting for the fixed versions

ajackson

I have just tried this link and it appears to be working 

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

JBrazell

Found the best response.  Make sure you are using version 3.5  Link is here.
https://download.red-gate.com/checkforupdates/SQLSearch/SQLSearch_3.5.0.2590.exe

ajackson

I have just tried this link and it appears to be working 

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

JBrazell

Found the best response.  Make sure you are using version 3.5  Link is here.
https://download.red-gate.com/checkforupdates/SQLSearch/SQLSearch_3.5.0.2590.exe

rgeisert

Umair said:

I installed version 3.5 and that works fine, downloaded it from here: https://download.red-gate.com/checkforupdates/SQLSearch/SQLSearch_3.5.0.2590.exe

This works.  Thank you!

cebland

This isn't working for me as that version of SQLSearch (3.5.0.2590) was already installed before upgrading to SSMS version 18.5.1.  I tried to install SQLSearch version 3.5.1.2598 to get around that, but it just says that "SQLSearch Version 3.5 is already installed".

As the "Repair" option also isn't available for the "SSMS Integration Pack Framework 1", is there any other way to get SQLSearch functional again in SSMS?...

thzman

I found a note in the support section.

https://productsupport.red-gate.com/hc/en-us/articles/360011203197-SQL-Search-doesn-t-work-with-SSMS-18-5-1

If you have Dependency Tracker installed but don't use it, do an uninstall of that application.

This fixed the SQL Search issue for me at least. No information on why this is though.

Omid

I have the same problem. I guess the ToolBelt installer is copying some new VC++ dlls or something that cause the problem. Even after uninstalling or downgrade to SQL prompt v9.0 did not help

ostandage

Hi everyone, 

We have fixed an issue with SQL Dependency Tracker which was causing some issues with SQL Search. This has been confirmed to work with the latest version of SQL Search and SSMS 18.6.

If you are still experiencing problems, please update to SQL Dependency tracker 3.3.4 to fix this. 

Thanks, 

Owen