We've had a few reports of this but never really gotten to the bottom of it. First thing to check though is that you're definitely connected to a database in the object explorer? If so you could try closing SSMS, and clearing out the %LocalAppData%\Red Gate\SQLSearch 3\Indexes folder, then reloading and trying again.
I have the same problem here, SSMS 18.1 , SQl Serach 3.2.7.2379.
I opened SSMS via WIN-R with commandline server parameter -> ssms -s servername Object explorer is open and connected to the server, A connected query window is also open. When I now start sql search the input boxes are grayed out. I also tried to delete the appdata before.
When I now connect to a server (from connect on top of object explorer) then the textboxes get white and I can enter search strings.
If thats the case it suggests something is stalling in the connection on startup. But I still can't reproduce it in debugging so just can't find out where.
Me too: SQL Server Management Studio 15.0.18131.0 Microsoft Analysis Services Client Tools 15.0.1347.0 Microsoft Data Access Components (MDAC) 10.0.18362.1 Microsoft MSXML 3.0 6.0 Microsoft Internet Explorer 9.11.18362.0 Microsoft .NET Framework 4.0.30319.42000 Operating System 10.0.18362 SQL Search 3.3.0.2332
AV: Eset Endpoint 7.1
Restarting didn't always help. Clearing Indexes helped this time.
This is now happening to me after upgrading to SSMS 18.5 and SQL Search 3.5.0.2590. Disconnecting and reconnecting in Object Explorer fixes it for that session, but once SSMS is closed, it continues to happen when opening SSMS again. If it helps, I only have SQL Prompt and SQL Search installed.
Can I just report bug here. Ssms Search gets enabled by opening connection, but it seems it does not register that connections are already open on start ( by other plugins ). Can you please fix this, it is really annoying. Do not enable plugin on connection open, connections are already open, just check for connections or enable on default.
Same problem here: Starting "SSMS" with "-s dbserver" option results also in grayed search box. I need to close and reopen the connection before I'm able to use it. This is really anoying as I'm used to start always ssms with -s .
Answers
If so you could try closing SSMS, and clearing out the %LocalAppData%\Red Gate\SQLSearch 3\Indexes folder, then reloading and trying again.
I have the same problem here, SSMS 18.1 , SQl Serach 3.2.7.2379.
I opened SSMS via WIN-R with commandline server parameter -> ssms -s servername
Object explorer is open and connected to the server, A connected query window is also open.
When I now start sql search the input boxes are grayed out. I also tried to delete the appdata before.
When I now connect to a server (from connect on top of object explorer) then the textboxes get white and I can enter search strings.
Jürgen
I have Sophos Endpoint Security and Control installed. This slows down starting programms in an remarkable way.
Jürgen
SQL Server Management Studio 15.0.18131.0
Microsoft Analysis Services Client Tools 15.0.1347.0
Microsoft Data Access Components (MDAC) 10.0.18362.1
Microsoft MSXML 3.0 6.0
Microsoft Internet Explorer 9.11.18362.0
Microsoft .NET Framework 4.0.30319.42000
Operating System 10.0.18362
SQL Search 3.3.0.2332
AV: Eset Endpoint 7.1
Restarting didn't always help.
Clearing Indexes helped this time.
Simon.
Clearing out the index folder hasn't helped.
SQL Search 3.3.1.2410
I can't see anything obvious in the logs.
Uninstalling and reinstalling didn't help, SQL Search 2 & 3 folders were removed from %LocalAppData% after uninstall.
Reconnected server in Object explorer help until SSMS is reopened.
Starting "SSMS" with "-s dbserver" option results also in grayed search box. I need to close and reopen the connection before I'm able to use it.
This is really anoying as I'm used to start always ssms with -s .
SSMS 18.5 ( 15.0.1833.0)
SqlSearch 3.5.0.2590