SSMS 17.3 and Sql Search 3.0.3

FTT

I just installed SSMS 17.3 and then Sql Search 3.0.3 and I can't get Search to index and load anything. It freezer when I open it, and then returns nothing. It initially shows my active database but then that goes away. Is this a bug, or a local permission issue?

Jessica R

Thanks for your post and sorry to hear you're running into an issue @FTT!

I suspect that it may be either a permissions issue or a problem with how SQL Search is connecting to the database, but the log files should hopefully confirm this-- if you check the last few files in %localappdata%\Red Gate\logs\SQLSearch 3 do you see any errors?

NaMCat

I had the same problem.

I find in log in this situation :
ERROR RedGate.SQLSearch.Addin.Tab.Controller - Search failed: 'DB1 on SQLSERV1' is not indexed

Solution:
https://forum.red-gate.com/discussion/80682/getting-generic-index-error-on-single-database

FTT

I did two things and I'm not sure what made it work. 1) I uninstalled and reinstalled SSMS and Sql Search. 2) I had the DBA give me read-access to all DBS, not just the couple I'm working on (I'm a consultant and they don't want to give me anything but read-only). Maybe it was the fresh install, maybe it was getting read-only access to the entire server/all dbs? Both? Either way it works now!

Jessica R

Hi @FTT,

That's great to hear!

If any problems return, just send across the log files and we can take a look for more detail.

gavinboyce

Sorry guys, I get the same issue. I've just installed SQL Search for the first time into SSMS 17.3.
I tried to delete the files from this link: https://forum.red-gate.com/discussion/80682/getting-generic-index-error-on-single-database

Never mind - all working now after a couple of attempts

Jessica R

Sorry to hear that @gavinboyce! Can you please send it to support@red-gate.com?

gavinboyce

@Jessica R all good now. A few tries at it fixed the issue and I'm working now.

Jessica R

Glad to hear it @gavinboyce!