SQL Search does not working on SSMS 2016

Mario

Hello,

I installed SQl-Search without any issues, but when i start the tooln all selection fields are disabled (grayed out). So I'm not able to use the tool. Have you any idea, how I can fix this problem?

Kind Regards,

Mario

 

AshaPatel

Hi Mario,

Have you opened any server connections? SQL Search can use any connections you have open, if you try to connect to a SQL Server instance the boxes should stop being greyed out.

Thanks,
Asha

Mario

Hello Asha,

thanks you for your quick reply. Yes, I'm connected to a server, bu the fields stay disabled.

Kind regards,

Mario

seekwell

Hi, I am seeing the same issue. Did you ever find a solution you can share?

JPP

Same issue for me as well. I just installed v3.1.6.2050.

AshaPatel

Hm interesting. Has anyone used a previous version of SQL Search and had it work normally? If so it looks like this could have been a problem introduced in the latest version.

AshaPatel

Also can you confirm the version of SQL Search you are using? The most recent version should be v3.1.6.2042.

Thanks,
Asha

Mario

Hello Asha,

I'm using Version 3.1.6.2050

I do not know if i used a previous version, but the tool did not work right from the beginnig.

King Regards,

Mario

AshaPatel

Hi Mario,

Have you set any non-default options in the SQL Server connection you are currently connected to? For instance, are you using an encrypted connection or not trusting the server certificate?

Thanks,
Asha

seeker5cs

Has anyone come up with a solution to this. We are running the latest downloadable version of SQL Search on SSMS 2016 (both are fresh installs) all search items are grayed out

Mario

Unfortunately, I could not find a solution. That's why I installed SSMS 2014 again. There SQL Search works without problems. However, I would be happy to find a solution to the problem.

AshaPatel

Hi,

We have found a potential issue that could be stopping SQL Search from working. We recently introduced some functionality where SQL Search would remember some of your preferences and store this in an xml file to carry those preferences forward. It seems this file can end up corrupted and in some cases this stops SQL Search from working. 

We haven't tracked down the cause yet, but in the meantime you can rectify this by deleting the file at "C:\Users\<username>\AppData\Local\Red Gate\SQLSearch 3\SavedSettings.xml". Hopefully on the next startup SQL Search will appear again.

Sorry about this, I hope this works for you!
Asha

dsmsql

I had this same issue with SSMS 18.4 connecting to a Sql Server 2014 database. I am not sure what caused the issue, but simply restarting ssms was able to fix the issue. The only thing that I did that may have had an impact is that I changed some of the settings within sql prompt. 

ronald_barr

Same issue but the problem was caused by the file "LoggingConfiguration.XML". I removed it and Search became active again. The other file mentioned previously was no on my PC.

drother

I have deleted LoggingConfiguration.xml from the directory indicated and restarted SSMS.  The file LoggingConfiguration.xml is recreated and I am still unable to use SQL Search with a SQL Server 2014 instance.

JasonDWilson

I know this is an old issue, but I've had this issue and found this corrects it.  Delete or rename this folder:  C:\Users\<username>\AppData\Local\Red Gate\SQLSearch 3