SQL Search not working, not connecting

• 
  I've figured out the problem. It does not work when connections are using:
  
  
  

  Hrvoje April 03, 2018 15:00

  - 0 +
• 
  Hi Hrvoje,
  
  Thanks for your post, sorry to hear you were having an issue!
  
  I shall raise this with the developers and let you know any outcomes. In the meantime, there has been a newer version released recently that is available for download using the below link:
  
  ftp://support.red-gate.com/patches/SQLSearch/29Mar2018/SQLSearch_3.1.2.1997.exe 
  
  From your screenshot it doesn't look like you're on this version. If you upgrade to this version do you still see the same issue?
  
  Thanks,
  Asha

  AshaPatel April 03, 2018 15:13

  - 0 +
• 
  No, it did not solve the issue.

  Hrvoje April 03, 2018 15:23

  - 0 +
• 
  Hi Hrvoje,
  
  Thanks for the fast update! I shall pass this along to the developers and will keep you updated on any progress.
  
  Can I just check, do you have a workaround or is this blocking you from using SQL Search?
  
  Thanks,
  Asha

  AshaPatel April 03, 2018 15:25

  - 0 +
• 
  The workaround is very simple, I just uncheck these options and it works.
  SQL Server would still use secure connection despite those options being unchecked if "Force encryption" is turned-on on the server.

  Hrvoje April 03, 2018 15:28

  - 0 +
• 
  That's good to know - thanks very much! 
  

  AshaPatel April 03, 2018 15:29

  - 0 +
• 
  I'm having the same issue I think.  Just need to locate that connection properties window.

  Searching April 16, 2019 15:40

  - 0 +
• 
  Depending on the version of SSMS you're using, click Options on the connection dialogue:

  
  

  
  

  Russell D April 23, 2019 10:19

  - 0 +

Add comment

Please sign in to leave a comment.