SQL Search does not start in SSMS 18.5

Question

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?

Is there anything in the log file (`%localappdata%\Red Gate\Logs\SQLSearch 3`) that might show what the problem is? — adrianbanks, Apr 17 '20 at 14:16
Having the same issue, just updated ssms to 18.5 and SQL search won't open. Nothing in the logs as well. — Umair, Apr 17 '20 at 22:19
Because this is top on Google: if in someone's case, it DOES start but is greyed out, disconnect object explorer and then reconnect to make it work. — aderchox, Jan 11 '22 at 06:28

Umair · Answer 1 · 2020-08-19T14:37:58.753

33

Ok there is some issue with SQL Search version 3.0, but when I tried SQL Search version 3.5 it is working fine. Download it from here: v3.5.2.2607

More details here

Newer versions of SQL Search are listed here.

edited Aug 19 '20 at 14:37

answered Apr 17 '20 at 22:29

Umair

4,864
3
28
47

3

Thanks, the problem is that the default download page points still to version 3.4. https://www.red-gate.com/products/sql-development/sql-search/installer/ – Vojtěch Dohnal Jul 08 '20 at 10:48
3.5 works for me too. Not sure why the download from RedGate is 3.4 though. – nonpoliticaltag Aug 25 '20 at 23:38
1

Still broken as of 9/9/2020. 3.5 working it appears. – SQLJax Sep 09 '20 at 14:55
1

Try removing and install this exact version: v3.5.2.2607 – Umair Sep 09 '20 at 15:08
1

I think @SQLJax is trying to say that the default download from the Redgate site is still 3.4x and broken. I am surprised that they haven't updated it yet. – Shashank Shekhar Sep 10 '20 at 21:03
Got it... Yes, it's surprising they have not yet updated even though they know and replied to a similar issue on their own forums. – Umair Sep 10 '20 at 21:07
@Shekar Thank you. That was what I was trying to get across. – SQLJax Sep 11 '20 at 14:32

score 1 · Answer 2 · answered Oct 26 '22 at 08:59

1

Try to install this version : https://download.red-gate.com/checkforupdates/SQLSearch/SQLSearch_3.5.0.2590.exe

It works fine for me

answered Oct 26 '22 at 08:59

Yassine

331
1
3
9

score 0 · Answer 3 · answered Nov 10 '21 at 15:24

I'm seeing the same issue in SQL Search 3.5.5.2703

The Redgate Forums have this workaround which worked for me:

I think you are running into an issue we are aware of and working on. Apologies for the hassle! As a workaround, could I ask you to try the following?

disconnect your SQL server from SSMS Object explorer

Close and reopen SQL Search

Reconnect your SQL Server

score 0 · Accepted Answer · answered Jan 11 '22 at 07:20

0

SSMS 18.10 + latest SQLSearch - work fine.

answered Jan 11 '22 at 07:20

ZedZip

5,794
15
66
119

SQL Search does not start in SSMS 18.5

4 Answers4