Important Update: Cohesity Products Knowledge Base Articles
All Cohesity Knowledge Base Articles are now managed via the Cohesity Support Portal: https://support.cohesity.com/. The Knowledge Base articles available here will not reflect the latest information or may no longer be accessible.
Problem
Event ID 13360 after moving Enterprise Vault SQL databases from one SQL server to another SQL server with named instances.
Error Message
Event: 13360
Category: Directory Service
Description: An error was detected while accessing the Vault Database 'TMP_MASTER_TMP_FOR_536708329' (Internal reference: CC1):
Description: [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Invalid Instance()).
SQL Command: N/A
Additional Microsoft supplied information:
Source: Microsoft OLE DB Provider for ODBC Drivers
Number: 0x80004005
SQL State: 01000
Native Error: 00000014
HRESULT 0xc0043433
V-437-13360
When attempting to Test ODBC connections of EV System DSN's we receive the following:
Connection failed:
SQL State: '01000'
SQL Server Error: 14
[Microsoft][ODBC SQL_Server Driver][DBNETLIB] ConnectionOpen (Invalid Instance())
Connection failed:
SQL State:'08001'
SQL Server Error: 14
[Microsoft][ODBC SQL_Server Driver][DBNETLIB]Invalid Connection
Cause
The preceding can occur when the SQL Server is using a named instance.
Solution
HKEY_LOCAL_MACHINE\Software\KVS\Enterprise Vault\Directory\Directory Service\SQLServer Name
Modify the SQLServer Name Key to reflect SQL Server Name\Named Instance.
If the error relates to a specific database then confirm that the SQL Server values are correct under the Vault Store properties / database tab in the Admin Console and also that the EnterpriseVaultDirectory Database tables below contain the correct Server and Instance names: