SQL Search2 is not working - Exception generated
iCodeHaha
Posts: 3
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
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
Comments
Let me know what happens.
David
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.
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