SQL Search 3.4.1.2506 not working with ssms 15.0

partycola

I just updated SSMS, and once I finished that the SQL Search button stopped working (clicking did nothing).

I downloaded and reinstalled SQL Search, and still nothing.

Here are my specs:

SQL Server Management Studio                        15.0.18330.0
SQL Server Management Objects (SMO)          16.100.37971.0
Microsoft Analysis Services Client Tools            15.0.19040.0
Microsoft Data Access Components (MDAC)    10.0.18362.1
Microsoft MSXML                                                 3.0 6.0
Microsoft .NET Framework                                  4.0.30319.42000
Operating System                                                10.0.18363

Sarah B

Hi @partycola and @Curt392

Could you please try upgrading to the latest version using the following link?
https://download.red-gate.com/checkforupdates/SQLSearch/SQLSearch_3.5.0.2590.exe 

It should resolve your issue.

Curt392

Same thing for me.  Same specs as well.  Two differences from a working computer:

Fails also:
Microsoft Data Access Components (MDAC) 10.0.19041.1

Operating System 10.0.19041

Works:
Microsoft Data Access Components (MDAC) 10.0.17763.1

Operating System 10.0.17763  (Server 2019)

dalew

Sarah B said:

Hi @partycola and @Curt392

Could you please try upgrading to the latest version using the following link?
https://download.red-gate.com/checkforupdates/SQLSearch/SQLSearch_3.5.0.2590.exe 

It should resolve your issue.

@Sarah B

Thank you for this , I was experiencing the same issues, downloaded and installed the link suggested and can confirm that all is now working correctly.

Curt392

As a side note, I had to download a full package and let it update all the pieces to get everything working again.  The fix did work for SQLSearch but not Prompt (no surprise).

partycola

That fixed it. Thank you.