SQL Search Disappeared after upgrade to SQL 2012

andykr

I had everything running nicely in SQL 2008R2 then today I installed (alongside) SQL Server 2012. Now The Redgate toolbar will not load when opening SSMS in 2012, and SQL Search is totally missing.

I have stopped the SQL 2008 service, uninstalled SQL Search and SSMS Integration pack and reinstalled both. No difference. Close SSMS and the Redgate toolbar will not reload on re-start, and SQL Search is not available at all.

When I manually open the Redgate toolbar in 2012 I do get SQL Source Control and Tab Management, but no SQL Search.

Additional: And if I re-open SSMS 2008 I get all the tools, including SQL Search!

Any suggestions?

Libertarian

I have SQL Search 1.1.9.57 installed on SQL2008.R2. I did a side by side install of SQL 2012. SQL Search is still available to my 2008R2 installation, but does not come up with my 2012. Do I need to upgrade to Search 2? Is there a way to implement the Search 1 in 2012?

Otherwise I have to go to the CIO and make a business case for non-standard software on my PC. (Even if free.)

Beth Aitman

You've run into a known problem - when you install a new version of SQL Server, you need to repair the SSMS Integration Pack Framework to get SQL Search working in the new version.

There are instructions in the documentation: http://documentation.red-gate.com/displ ... ent+Studio

LukeA

Ahh.. Thanks so much Beth. Repairing the framework got the SQL search up and working again!