SQL Search are grayed out

• 
  Hi @osamaroo
  
  We are aware of a bug relating to this, could you please upgrade to SQL Search 3.5.3. If the problem still persists we have a workaround until we are able to fix this: 
  
  

  1. Disconnect from the SQL Server in SSMS you want to search
  2. Close and reopen SQL Search
  3. Reconnect the SQL Server

  
  Hopefully these steps will work in the meantime, apologies for the inconvenience caused.
  
  Thanks, 
  
  Owen

  ostandage December 16, 2020 09:06

  - 0 +
• 
  Yes ostandage, that does work.   Needless to say there have been many reports of this problem over months.   Is there an ETA?  Thanks.

  ejs January 04, 2021 19:25

  - 0 +
• 
  I am having the same issue with SQL Search no longer working (all the boxes are greyed out).  I've uninstalled SQL Search and reinstalled, still nothing works.  I would really like to get it working again, so any advise would be appreciated.

  Margo February 12, 2021 16:07

  - 0 +
• 
  This is still happening, every time I try to use SQL Search.

  scollis February 22, 2021 11:46

  - 0 +
• 
  This is now happening to me.  I didn't notice it until recently, maybe the last few weeks.  It has happened only a few times.

  mdullni1 March 02, 2021 16:24

  - 0 +
• 
  Encountering the same issue on 3.5.5. The above workaround worked for now.

  LJS July 30, 2021 10:47

  - 0 +
• 
  It's happening to me on 3.5.5.2703.  The workaround above does not work for me.  All boxes continue to be greyed out no matter what I try.

  sdh August 12, 2021 16:14

  - 0 +
• 
  I've even raised a support ticket on this and been told there's no ETA for a fix.

  scollis August 12, 2021 17:19

  - 0 +
• 
  Happening to me too. Following shows up in log
  
  

  2021-08-17 09:13:27.396 +01:00 [Error]  [RedGate.SQLSearch.Addin.Tab.DatabaseConnector]: Could not load database list

  2021-08-17 09:13:27.453 +01:00 [Error]  [RedGate.SQLSearch.Addin.LoggingErrorHandler]: Failed to get the object hierarchy

  AleSlugs August 17, 2021 18:05

  - 0 +
• 
  I'm using SQL Search and SQL Prompt.
  The previous suggestions didn' t work for me. Opening and close the ' Tab History'  before starting SQL Search did the trick for me.
  SSMS 18.9.2/SQL Search 3.5.5.2703

  goosvanbeek September 13, 2021 13:04

  - 0 +
• 
  I disconnected from automatically connected DBs and reconnected, and SQL Search magically got enabled.

  yvarshavsky September 20, 2021 16:00

  - 0 +
• 
  This "workaround" does work, however this is August 2022 and the bug was reported Dec 2020 (almost 2 years ago).  Being a software engineer I understand the "priority" queue, but this one seems a little more significant than to be ignored for 2 years?

  Rob_Ainscough1 August 19, 2022 17:44

  - 0 +
• 
  This just happened to me as well. The workaround does work, but I agree that it seems odd this hasn't been fixed several years on from the initial bug discovery.

  GWL August 26, 2022 18:31

  - 0 +

Add comment

Please sign in to leave a comment.