enterprise vault service unavailable
Hi;
We just move our EV databases to the new SQL server. We able to see archived mailes via icons on Outlook. But on search .asp we took the enterprise vault service unavailable error. and also on the event view we see this log.
An error was detected while accessing the Vault Database 'EnterpriseVaultDirectory' (Internal reference: {CADODataAccess::OpenRecordset} [.\ADODataAccess.cpp, lines {2650,2652,2653,2656,2659,2663}, built Jul 10 17:51:36 2013]):
Description:
Invalid object name '#rootidentities'.
SQL Command:
GetObjectsBySIDs
Additional Microsoft supplied information:
Source: Microsoft OLE DB Provider for SQL Server
Number: 0x80040e37
SQL State: 42S02
Native Error: 00000208
HRESULT 0x80040e37
Can you please help us urgently.
The cause of the problem is sql server collation.
The SQL server default collation must be same with EV sql collations.
Thanks for all.
Regards