SQL Search not working, not connecting

Hrvoje

I am using SSMS v17.6 and newest SQL Search. It shows the server but not databases.

RichardL

Hi @Hrvoje

Thanks for your post. 

A newer version was released the day after your post and I have a link to the download below. 

ftp://support.red-gate.com/patches/SQLSearch/04Apr2018/SQLSearch_3.1.3.2006.exe

I hope this helps. 

Best

Richard Lynch. 

PF_HL

I had the same issue when I was connected using Active Directory Authentication. Using SQL Server Authentication solved it.

Random Lengths

Not using AD in my case is not an option.  I've upgraded to the version posted here, and it still just gives me the same blank tab, not working

Random Lengths

But, I will note, concocting an SQL account, and using it did work, it's just not an acceptable solution.

Random Lengths

I found an error message in your logs:


Error Number:-2146893019,State:0,Class:20
24 Apr 2018 16:17:43.219 [1] ERROR RedGate.SQLSearch.Addin.Tab.DatabaseConnector - Could not load database list
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.) ---> System.ComponentModel.Win32Exception (0x80004005): The certificate chain was issued by an authority that is not trusted

It seems that if I use an AD account, and select Encrypt the connection, and Trust Certificate (it's self-signed in our case) then SQL Search fails.  If I turn off the encryption in the connection it works.