Best Of

SQL Search - Unusable (grayed out)

My SQL Search is not allowing me to provide an object value. Sometimes it works and other times it doesn't. I haven't been able to identify a pattern of when and when it does not work.

Image: https://us.v-cdn.net/6029854/uploads/editor/ov/88ikdgh0wcx0.png

I have tried re-installing.

SSMS (v18.2)
15.0.18142.0

SQL Search
3.3.1.2410

Is anyone else having this issue? Any suggestions?

xbradt

5 ·

Re: SQL Search 3.4.2.2567 not working with SSMS 18.5?

Just installed this version and works fine : https://download.red-gate.com/checkforupdates/SQLSearch/SQLSearch_3.5.0.2590.exe

JodyBarford

8 ·

Re: SQL Search does not start in SSMS 18.5

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

Umair

5 ·

SQL Search does not start in SSMS 18.5

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?

Win32nipuh

5 ·

SQL Prompt for Azure Data Studio

Hi there
I'm not quite sure if this is the correct subforum for my question so first let me say "sorry" if it's not.
Are there any plans for a Microsoft Azure Data Studio - SQL Prompt yet?
If not is there a way to get a notifcation once SQL Prompt is released at redgatefoundry.com?

King regards,
Nils

Nils_L

7 ·

Re: SQL Search not returning any results

I was having this same issue.

I resolved it by replacing the System.Data.SQLite.dll in C:\ProgramData\Red Gate\SQL Search\Source with the older version (1.0.85.0, copied from SQL Prompt 9 folder, C:\Program Files (x86)\Red Gate\SQL Prompt 9).

It looks like it's likely due to the multiple versions of SQLite being used and the x64/x86 versions not being published appropriately for the new version (1.0.110.0)

BTW, this did not work when I replaced it with 1.0.109.0 - my guess it has to do with the changes to the library pre-loader introduced in 1.0.91.0.

I now know that this happens because SQL Prompt uses version 1.0.85.0 and Search uses 1.0.110.0, but tries to use the Prompt version of SQLite.Interop.DLL. So as long as both Prompt and Search use the same version, it will work fine.

Looks like an integration testing problem! Prompt and Search both work fine alone, but if you install both of them then Search breaks.

Vivan

8 ·

Re: SQL Prompt 8 and SSMS 2017 issue

Hi everyone,

I'm sharing @Sal 's finding for this issue. Can you please check your log file to see if you have similar error like this:

System.Data.SqlClient.SqlException (0x80131904): A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 - The certificate chain was issued by an authority that is not trusted)

In this case, please make sure to enable the "Trust Server Certificate" under Connection Properties when you connect to SQL server?

I hope this helps!