1. Support
  2. Knowledge base
  3. 100029829

When deleting a Vault Store or Vault Store Partition an Event ID 13360 error is generated regarding Ad Hoc Queries

Article: 100029829
Last Published: 2021-09-03
Ratings: 0 0
Product(s): Enterprise Vault

Problem

The error "Failed to delete an entry from the Directory Service" will be reported when attempting to delete a Vault Store or a Vault Store Partition.  The following errors will also be recorded in the Enterprise Vault Event Viewer log:
 

Error Message

Source: Enterprise Vault
Category: Directory Service
Type: Error
Event ID: 13360
Description:
An error was detected while accessing the Vault Database 'EnterpriseVaultDirectory' (Internal reference: .\ADODataAccess.cpp (CADODataAccess:ExecuteSQLCommand) [lines {1356,1358,1373,1405}] built Feb 21 23:15:28 2007):

Description:
SQL Server blocked access to STATEMENT
'OpenRowset/OpenDatasource' of component 'Ad Hoc Distributed queries' because this component is turned off as part of the security configuration for the server. A system administrator can enable the use of 'Ad Hoc Distributed Queries' by using 'sp_configure. For more information about enabling 'Ad Doc Distributed Queries', see "Surface Area Configuration" in SQL Server Books Online.

SQL Command:
SELECT TOP 1 ldPartition FROM OPENDATASOURCE)'SQLOLEDB', Data Source=&;integrated security=SSPI').EVVaultStore.dbo.saveset WHERE (IdPartition = ?)

Additional Microsoft supplied information:
Source: Microsoft OLE DB Provider for SQL Server
Number: 0X80040e14
SQL State: 4200
Native Error: 00015281
HRESULT 0x80040e14

V-437-13360

Source: Enterprise Vault
Category: Directory Service
Type: Error
Event ID: 8453
Description:
The EnterpriseVault.DirectoryService object reported an error.
The error code was 0x80040e14

V-437-8453

Solution

There are two ways in which Ad Hoc Distributed Queries can be enabled: Through Surface Area Configuration Manager or the SQL Query Analyzer.

SQL Server Surface Area Configuration Manager
  1. Open the SQL Server Surface Area Configuration Manager on the server that contains the Enterprise Vault Directory database.
     
  2. Click Surface Area Configuration for Features, click Ad Hoc Remote Queries, check 'Enable OPENROWSET and OPENDATASOURCE support' and press OK.

    Note: No restart of the SQL server, services or Enterprise Vault servers are required.

SQL Query Analyzer

Run the following query:

sp_configure 'show advanced options', 1
RECONFIGURE
GO
 
sp_configure 'Ad Hoc Distributed Queries', 1
RECONFIGURE
GO
 
Delete the partition, and then afterwards if you wish to reinstate the default settings run:

 
sp_configure 'Ad Hoc Distributed Queries', 0
RECONFIGURE
GO
 
sp_configure 'show advanced options', 0
RECONFIGURE
GO
 
Note: No restart of the SQL server, services or Enterprise Vault servers are required.

More about Ad Hoc Distributed queries can be read here:

https://msdn2.microsoft.com/en-us/library/ms189978.aspx
 

Applies To

All SQL Server versions

References

Etrack : 8453 Etrack : 13360 UMI : V-437-13360 UMI : V-437-8453

Was this content helpful?

Article Languages