SQL Search are grayed out

osamarooosamaroo Posts: 1 New member
in SQL Search
When trying to use SQL Search, the boxes are grayed out
Tagged:
· Share on Twitter

Comments

  • ostandageostandage Cambridge Posts: 74 Silver 1
    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
    Software Engineer
    SQL Prompt / SQL Search
    · Share on Twitter
  • ejsejs Posts: 6 New member
    Yes ostandage, that does work.   Needless to say there have been many reports of this problem over months.   Is there an ETA?  Thanks.
    · Share on Twitter
  • MargoMargo Posts: 3 New member
    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.
    · Share on Twitter
  • scollisscollis Posts: 27 Bronze 3
    This is still happening, every time I try to use SQL Search.
    · Share on Twitter
  • mdullni1mdullni1 Posts: 26 Bronze 3
    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.
    · Share on Twitter
  • LJSLJS Posts: 1 New member
    Encountering the same issue on 3.5.5. The above workaround worked for now.
    · Share on Twitter
  • sdhsdh Posts: 1 New member
    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.
    · Share on Twitter
  • scollisscollis Posts: 27 Bronze 3
    I've even raised a support ticket on this and been told there's no ETA for a fix.
    · Share on Twitter
  • AleSlugsAleSlugs Posts: 1 New member
    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
    · Share on Twitter
  • goosvanbeekgoosvanbeek Posts: 4 Bronze 1
    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
    · Share on Twitter
  • yvarshavskyyvarshavsky Posts: 1 New member
    I disconnected from automatically connected DBs and reconnected, and SQL Search magically got enabled.
    · Share on Twitter
  • Rob_Ainscough1Rob_Ainscough1 Posts: 1 New member
    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?
    · Share on Twitter
  • GWLGWL Posts: 1 New member
    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.
    · Share on Twitter
Sign In or Register to comment.