SQL Search - Unusable (grayed out)

• 
  Morning!
  We've found that if you open the SQL Search tab before connecting to the database, the tool should work as expected.
  
  Can you try this and confirm this is the case on your end as well?
  
  

  squigley October 02, 2019 19:38

  - 0 +
• 
  I'm having the exact same issue; the search text box is greyed out, and it's been consistent. It works in SSMS 17, but not 18.

  
  

  SSMS v18.3.1 (15.0.18183.0), dark theme turned on
  

  SQL Search v3.3.1.2410

  
  

  Opening SQL Search before connecting to the database doesn't help.
  
  

  anthony43 October 08, 2019 14:44

  - 0 +
• 
  exact same issue. Started when i went from 18.1 to 18.3.1 . Opening Search before connection to DB does not work for me either.  Did a fresh install (uninstall/Install) and it started working but did not the next day.  I cant find a pattern either.
  

  cd7283 October 15, 2019 17:17

  - 0 +
• 
  I have the same issue.   I have found that if I open it when I first start SSMS, it is no problem.  It is only later, when I want to search for something that I open Search and everything is grayed out.  SSMS v18.3.1, Search v3.2.7.2379
  
  squigley said:

  Morning!
  We've found that if you open the SQL Search tab before connecting to the database, the tool should work as expected.
  
  Can you try this and confirm this is the case on your end as well?
  
  

  
  

  Keith October 16, 2019 17:06

  - 0 +
• 

  squigley said:

  Morning!
  We've found that if you open the SQL Search tab before connecting to the database, the tool should work as expected.
  
  Can you try this and confirm this is the case on your end as well?
  
  

  I'm still having the same issue occur irregularly.

  xbradt October 16, 2019 17:42

  - 0 +
• 

  squigley said:

  Morning!
  We've found that if you open the SQL Search tab before connecting to the database, the tool should work as expected.
  
  Can you try this and confirm this is the case on your end as well?
  
  

  I am still facing the same issue. SQL Search tab is still grayed out. Opening SQL Search before connecting to a db does not help. Have reinstalled several times.

  bmaru October 31, 2019 19:32

  - 0 +
• 
  Hello All,
  I think
  " open the SQL Search tab before connecting to the database "
  
  should read...
  " open the SQL Search tab before connecting to the server "
  i.e. when starting SSMS and prompted to Connect to server, press Cancel, then Click SQL Search tab. This worked for me.. subsequently did not need to do that as effect persisted.
  

  simonc November 05, 2019 15:32

  - 0 +
• 
  " open the SQL Search tab before connecting to the database "
  
  should read...
  

  " open the SQL Search tab before connecting to the server "

  
  

  Doesn't work. When will this be fixed?
  

  
  

  forenheith November 12, 2019 11:25

  - 0 +
• 

  simonc said:

  " open the SQL Search tab before connecting to the server "
  i.e. when starting SSMS and prompted to Connect to server, press Cancel, then Click SQL Search tab. This worked for me.. subsequently did not need to do that as effect persisted.
  

  After updating to SSMS 18.4 had to do again..
  

  simonc November 13, 2019 13:58

  - 0 +
• 
  Same problem here had to do it 2 times in different order

  Vasim November 21, 2019 18:31

  - 0 +
• 
  And again after yesterday's Microsoft updates... 
  With 1909 to come... will see if need to do again 
  

  simonc December 12, 2019 11:43

  - 0 +
• 
  I have the same problem. I tried launching SQL Search before connecting to the database but it is still grayed out.

  Fishbait57 January 06, 2020 19:33

  - 0 +
• 
  Has there been any resolution to this issue?  I just started having the same issue, and nothing seems to fix it.  SSMS v18.4 and latest version of SQL search

  Egers January 30, 2020 17:57

  - 0 +
• 
  I am using SSMS v18.2 and downloaded the latest version of SQL Search.
  While installing, the setup says that it is only compatible with version 2017 and older.
  I'm not able to install SQL Search on SSMS v18.2 at all.
  Any idea about that behaviour ?
  

  ULRICHS February 20, 2020 09:23

  - 0 +
• 
  Same issue. Cannot use sql search as greyed out

  amandar March 13, 2020 00:30

  - 0 +
• 
  I deleted this product year ago. The team abandoned this project, nobody has been answering here for a long time

  forenheith March 13, 2020 04:50

  - 0 +
• 
  So sorry to hear SQL Search hasn't been functioning properly! 
  
  If you have any other Redgate plugins, please upgrade them to the latest version. Should problem persists, is it possible to share your SQL Search log so that we can investigate it further?
  
  Thanks.

  Tianjiao_Li March 27, 2020 11:01

  - 0 +
• 
  Where can we send the logs so you can investigate the issue?
  

  Ales1234 May 20, 2020 06:52

  - 0 +
• 
  For some reason I just started having this same exact issue. Opening SQL Search before connecting to any databases does seem to help. Not sure if it consistently fixes the problem but...

  ronmichael June 08, 2020 17:25

  - 0 +
• 
  This is a long standing issue, but I'm not sure Redgate is still updating sql search. I find that repairing my redgate installation solves the problem (from Add/Remove Programs in Windows 10), but temporarily.
  
  Note that I am using this version (3.5.0.2590):
  https://download.red-gate.com/checkforupdates/SQLSearch/SQLSearch_3.5.0.2590.exe 
  

  techvslife June 09, 2020 06:45

  - 0 +
• 
  (accidental duplicate post)
  

  techvslife June 12, 2020 07:28

  - 0 +
• 
  (accidental duplicate post)
  

  techvslife June 12, 2020 07:28

  - 0 +
• 
  (accidental duplicate post)

  techvslife June 14, 2020 01:24

  - 0 +
• 
  I had the same issue with 18.5.1, here's what worked for me:

  1. Uninstall SQL Search
  2. Open SMS
  3. Login to a DB if you want
  4. Close it
  5. Install SQL Search
     

  fsarlenga June 22, 2020 19:09

  - 0 +
• 
  I was having the same issue. All text boxes and combo boxes were grayed out. I disconnected from all servers.
  
  
  
  Then reconnected to a server. After that, all text boxes and combo boxes became enabled right before my very eyes.
  
  
  

  dwarwick February 11, 2022 19:04

  - 0 +
• 

  squigley said:

  Morning!
  We've found that if you open the SQL Search tab before connecting to the database, the tool should work as expected.
  
  Can you try this and confirm this is the case on your end as well?
  
  

  This is a horrible solution to this problem.  When you open SSMS, it automatically prompts you to connect to a server.   So, we have to either connect, disconnect, open SQL Search and reconnect.  Or, Don't connect, open SQL Search the Connect.  Either way, I don't use the search feature all that often, so, HABIT is to Connect when SSMS starts.  I am hoping there is a fix coming soon for this.

  mmoore February 17, 2022 13:37

  - 0 +
• 
  +1 to squigley for the helpul tip.  Agree with mmoore that this is a poor workaround and needs to be fixed asap.

  JRGerner April 01, 2022 04:18

  - 0 +
• 
  +1 The same applies to me, I have to regularly start SQL Search before connecting to a database, otherwise SQL Search is unusable. This is likely to happen during a forced restart of Windows, at the initiative of Windows Update for example.
  

  jcarenton April 18, 2022 11:09

  - 0 +

Add comment

Please sign in to leave a comment.