Best Of

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

5 ·

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!