SQL Search not working, not connecting

• 
  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. 

  RichardL April 13, 2018 12:42

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

  PF_HL April 23, 2018 17:57

  - 0 +
• 
  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 April 24, 2018 23:15

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

  Random Lengths April 24, 2018 23:17

  - 0 +
• 
  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.
  

  Random Lengths April 24, 2018 23:21

  - 0 +

Add comment

Please sign in to leave a comment.