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

Problem

When the Enterprise Vault Directory and Vault Store databases reside on SQL Server 2005, "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 2005 Surface Area Configuration Manager
  1. Open the SQL Server 2005 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:

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

Applies To

SQL Server 2005

Terms of use for this information are found in Legal Notices.

Search

Survey

Did this article answer your question or resolve your issue?

No
Yes

Did this article save you the trouble of contacting technical support?

No
Yes

How can we make this article more helpful?

Email Address (Optional)