SQL Search2 is not working - Exception generated

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

Moderator: dom.smith

SQL Search2 is not working - Exception generated

Postby iCodeHaha » Fri May 16, 2014 7:12 pm

Trying to open SQL Search 2 and I get this:
It was working for a day and it stopped working later.

Catastrophic failure (Exception from HRESULT: 0x8000FFFF (E_UNEXPECTED))

and in the log all I have is this:
12:58:57.397|Info |RedGate.SIPFramework|1 |Red Gate SSMS Ecosystem host connecting to SSMS.
12:58:57.412|Info |RedGate.SIPFramework|1 |RedGate.SIPFramework version: 1.0.1.2025
12:59:02.058|Info |RedGate.SIPFramework|1 |Red Gate SSMS Ecosystem host connecting to SSMS.
12:59:02.058|Info |RedGate.SIPFramework|1 |RedGate.SIPFramework version: 1.0.1.2025

Tried with no luck:
Repair/Uninstall/install of SQL Search and SIP Framework/restarted computer/restarted SSMS

SQL Server 2008
Windows 7
iCodeHaha
 
Posts: 2
Joined: Fri May 16, 2014 7:04 pm

Postby David Pond » Thu May 22, 2014 3:43 pm

Please could you delete C:\\ProgramData\\Red Gate\\SIPFw then repair the SIPFw installation.

Let me know what happens.

David
David Pond
Site Admin
 
Posts: 24
Joined: Tue Mar 06, 2012 7:13 pm
Location: Cambridge, UK

Postby iCodeHaha » Thu May 22, 2014 4:30 pm

It is working now.

This is what I did:
1) I repaired SIP framework.
2) Open SSMS but do not connect to a Database Engine.
3) Open SQL Search2
4) Connect to DB engine.

and it is working now. Since the DB is on a remote server, I guess I have to do this.

Thanks anyway.
iCodeHaha
 
Posts: 2
Joined: Fri May 16, 2014 7:04 pm

Postby David Pond » Thu May 22, 2014 4:41 pm

Great - thanks for letting me know. :-)

Actually I had a similar experience with the bug described in this thread. It only occurred when I opened a DB connection before opening SQL Search. http://www.red-gate.com/MessageBoard/vi ... hp?t=20504

Perhaps you can avoid your workaround with the fixed version: http://www.red-gate.com/products/sql-de ... -search/v2

David
David Pond
Site Admin
 
Posts: 24
Joined: Tue Mar 06, 2012 7:13 pm
Location: Cambridge, UK


Return to SQL Search 2

Who is online

Users browsing this forum: No registered users and 0 guests