SQL Search Disappeared after upgrade to SQL 2012

A free Management Studio add-in to search for SQL in your databases

SQL Search Disappeared after upgrade to SQL 2012

Postby andykr » Thu Jul 24, 2014 7:24 pm

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?
----
Regards
Andy Kramek
andykr
 
Posts: 5
Joined: Wed Dec 02, 2009 12:43 pm
Location: Akron, OH

Re: SQL Search Disappeared after upgrade to SQL 2012

Postby Libertarian » Mon Nov 03, 2014 9:59 pm

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.)
Libertarian
 
Posts: 1
Joined: Mon Nov 03, 2014 8:07 pm

Re: SQL Search Disappeared after upgrade to SQL 2012

Postby Beth Aitman » Tue Nov 04, 2014 11:42 am

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
Beth Aitman
 
Posts: 9
Joined: Mon Nov 04, 2013 11:10 am
Location: Cambridge

Re: SQL Search Disappeared after upgrade to SQL 2012

Postby LukeA » Tue Nov 04, 2014 12:48 pm

Ahh.. Thanks so much Beth. Repairing the framework got the SQL search up and working again!
LukeA
 
Posts: 1
Joined: Tue Nov 04, 2014 12:44 pm


Return to SQL Search 2

Who is online

Users browsing this forum: No registered users and 0 guests