Video Screencast Help
Search Video Help Close Back
to help
New in the Rewards Catalog: Vouchers for "Symantec Technical Specialist" and "Symantec Certified Specialist" exams.

Unable to delete un-used partition

Updated: 22 May 2010 | 1 comment
Marc van Duuren's picture
0 0 Votes
Login to vote
This issue has been solved. See solution.

I got the following issue and hope that someone can give me a hint to how to solve this.

 

We are using one Vault Store in which we have 4 partitions. Last month I created a partition by accident with the wrong settings. This partition is closed and has never been used, so I decided to delete it from within the Management Console. Unfortunately it won't work, giving me the following error message from with the Management Console:

"

Failed to delete an entry from the Directory Service ('Mail001 Ptn2')==> (my partition name)

The EnterpriseVault.DirectoryService ojbect reported an error.

NULL

"

 

The event viewer shows the following 3 events.

 

--------------------------------------------------------- -----

Type: Error

Source: Enterprise Vault

Category: Directory Service 

Event ID: 8453

 

Description:

The EnterpriseVault.DirectoryService object reported an error.
 
The error code was 0x80040e14
---------------------------------------------------------------

 

The above mentioned event shows 2 times. The event below shows only once:

 

--------------------------------------------------------- -----

Type: Error

Source: Enterprise Vault

Category: Directory Service 

Event ID: 13360

 

Description:

An error was detected while accessing the Vault Database 'EnterpriseVaultDirectory' (Internal reference: .\ADODataAccess.cpp (CADODataAccess::ExecuteSQLCommand) [lines {1379,1381,1396,1428}] built Jun 20 23:03:23 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 this server. A system administrator can enable the use of 'Ad Hoc Distributed Queries' by using sp_configure. For more information about enabling 'Ad Hoc Distributed Queries', see "Surface Area Configuration" in SQL Server Books Online.
 
 
SQL Command:
 SELECT TOP 1 IdPartition FROM OPENDATASOURCE ('SQLOLEDB', 'Data Source=NLEH2SQL001;integrated security=SSPI').EVMail001.dbo.Saveset WHERE (IdPartition = ?)
 
 
Additional Microsoft supplied information:
 
Source:       Microsoft OLE DB Provider for SQL Server
Number:       0x80040e14
SQL State:    42000
Native Error: 00015281
HRESULT  0x80040e14
--------------------------------------------------------- -----

discussion Filed Under:

Comments

MichelZ's picture
07
Jul
2008
0 Votes 0
Login to vote

Marc

 

The Eventlog entry provides much detail. It seems to be a SQL Configuration issue.

 

Have you tried this:

 

A system administrator can enable the use of 'Ad Hoc Distributed Queries' by using sp_configure. For more information about enabling 'Ad Hoc Distributed Queries', see "Surface Area Configuration" in SQL Server Books Online.

 

Cheers

Michel

www.quadrotech-it.com - All your EV Tools | www.techfreak.ch