SQL Search Greyed Out No controls usanble

• 
  Hi @rldawg
  
  Please can you try disconnecting SQL server from SSMS Object explore, close then open SQL Search, and then reconnect SQL Server? 
  

  Victoria W April 25, 2022 08:26

  - 0 +
• 

  Victoria W said:

  Hi @rldawg
  
  Please can you try disconnecting SQL server from SSMS Object explore, close then open SQL Search, and then reconnect SQL Server? 
  

  This worked for me. It was the explicit:
  

  1. Disconnect from all open database connections
  2. Closed SQL Search (I closed all other Redgate tabs I had pinned too)
  3. Opened SQL Search
  4. Connected to the database

  JR561 April 28, 2022 19:06

  - 0 +
• 

  JR561 said:

  Victoria W said:

  Hi @rldawg
  
  Please can you try disconnecting SQL server from SSMS Object explore, close then open SQL Search, and then reconnect SQL Server? 
  

  This worked for me. It was the explicit:
  

  1. Disconnect from all open database connections
  2. Closed SQL Search (I closed all other Redgate tabs I had pinned too)
  3. Opened SQL Search
  4. Connected to the database

  Yeah it seemed that the open tabs caused some kind of issue because SSMS kept beeping at me when I closed it down with the tabs still open (I leave them open knowing SQL prompt will persist them).  Normally that's not an issue.  But closing them all explicitly, then closing SSMS and re-opening it worked.

  rldawg April 29, 2022 06:53

  - 0 +
• 
  Actually I think one of the problems is that when I have open tabs and go to close SSMS, I get this error.  I have not transactions in progress.
  
  

  TITLE: Querying transaction count

  ------------------------------

  
  

  Unable to query transaction count

  
  

  ------------------------------

  ADDITIONAL INFORMATION:

  
  

  A transport-level error has occurred when sending the request to the server. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.) (Microsoft SQL Server, Error: 10054)

  
  

  For help, click: https://docs.microsoft.com/sql/relational-databases/errors-events/mssqlserver-10054-database-engine-error

  
  

  ------------------------------

  
  

  An existing connection was forcibly closed by the remote host

  
  

  ------------------------------

  BUTTONS:

  
  

  OK

  ------------------------------

  
  

  rldawg May 02, 2022 04:33

  - 0 +
• 
  It's really a pain. The SQL Search used to work fine. Today I just installed the Toolbelt Essentials. After the installation, then I got the same issue that everything was greyed out. I followed the instructions above to close the connections, close SQL Search, open SQL Search and then connect to the DB. It does work. However, when I got out of SSMS and came back next time, then I had the same issue and had to repeat the steps. That would really be a pain because I would have to remember to open SQL Search at launch before connecting. But I don't typically open SQL Search until I have to use it. Will there be a more permanent fix?

  Doris June 13, 2022 18:42

  - 0 +
• 

  Thank you all for your postings advising similar concerns with SQL Search.

  This will be escalated to our development team so they can investigate further and log a bug report if one doesn't already exist. If I am provided with a bug # I will endeavor to post on this forum post so it can be tracked.

  At this point it would not be possible to give a timeframe for resolution but any permanent fix would be included as part of a future release of SQL Search and would recommend checking release notes whenever a new patch is available to you.

  https://documentation.red-gate.com/ss/release-notes-and-other-versions

  
  

  I'll re-share JR561 comment from above as a work around solution:

  This worked for me. It was the explicit:
  

  1. Disconnect from all open database connections
  2. Closed SQL Search (I closed all other Redgate tabs I had pinned too)
  3. Opened SQL Search
  4. Connected to the database

  Jon_Kirkwood June 15, 2022 06:32

  - 0 +
• 
  Just wanted to note that I had this same issue today. Disconnecting from all databases, then opening the search, and then reconnecting to all databases fixed it for me as well.

  Bhendricks August 18, 2022 20:33

  - 0 +

Add comment

Please sign in to leave a comment.