How can we help you today? How can we help you today?

SQL Search2 is not working - Exception generated

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
0

Comments

3 comments

Sort by
  • David Pond
    Please could you delete C:\ProgramData\Red Gate\SIPFw then repair the SIPFw installation.

    Let me know what happens.

    David
    David Pond
    0
  • 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.
    iCodeHaha
    0
  • 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
    David Pond
    0

Add comment

Please sign in to leave a comment.