Unable to delete un-used partition
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
--------------------------------------------------------- -----
Comments
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
Would you like to reply?
Login or Register to post your comment.