What is the status for this fix? It is very annoying not to mention the interruption to working to have to close all my scripts that are open SSMS, disconnect the server, open SQL Search, reconnect server.
I have the same issue. I am on all of the latest versions. When I go through the workarounds after reopening SQL Search, I see the two drop downs flash available while reconnecting to my server and then they go grey again as soon as the server completes its connection. Selecting Reindex or Cancel Indexing doesn't seem to do anything either.
I tried the disconnect and reconnect and the dropdowns flash for a second like they will work and then go back to grey. This hasn't worked for at least a year now.
I've been having the issue with the first time I bring up SQL Search in SSMS the boxes are all grayed out and I can't interact with it or type in a search. I have found that clicking on any server in the Object Explorer pane (even if not same server in context with SQL Search) fixes the issue for me each time.
I'm getting this too, but only on my local DEV machine - other installations are OK. Came to the forum and first pleased to see the issue mentioned but then disappointed that there is no real solution or comment from Redgate for an issue first mentioned over 4 months ago. Also, the help documentation took 4 minutes to load with the https://documentation.red-gate.com/ss3 site just spinning,
Answers
I think you are running into an issue we are aware of and working on. Apologies for the hassle! As a workaround, could I ask you to try the following?
- disconnect your SQL server
from SSMS Object explorer
- Close and reopen SQL Search
- Reconnect your SQL Server
Thank you!If I launch SSMS from Windows Start with no default Server/Database then SQL Search works properly.
Here is a snippet from by cmd file:
workaround instructions can be found only here in the forum.