SQL Search2 is not working - Exception generated

iCodeHaha

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

David Pond

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

Let me know what happens.

David

iCodeHaha

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.

David Pond

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