SQL Server linked server to Active Directory

From: Confused (anonymous_at_discussions.microsoft.com)
Date: 03/09/04


Date: Mon, 8 Mar 2004 18:46:07 -0800

When I try to connect a SQL Server to our Active Directory via SQL Server's 'Linked Servers', I get the following error:
Error 7301: Could not obtain a required interface from the OLE DB provider 'ADsDSOObject'.
OLE DB error trace [OLE/DB Provider 'ADsDSOObject' IUnknown:: QueryInterface returned ... IDBSchemaRowset].

Does anyone have any ideas on what may cause this error?



Relevant Pages

  • Re: Full Text Max Size?
    ... and depending upon what your is your SQL Server version and SP ... > from the OLE DB provider 'Full-text Search Engine'. ... > OLE DB error trace [OLE/DB Provider 'Full-text Search Engine' ...
    (microsoft.public.sqlserver.fulltext)
  • Active Directory as linked Server in SQL
    ... I have learnt that this can be done using linked server. ... OLE DB error trace [OLE/DB Provider 'ADSDSOObject' ICommandPrepare::Prepare returned 0x80040e14]. ...
    (microsoft.public.sqlserver.server)
  • RE: OLE DB to Active Directory from SQL 2000
    ... OLE DB error trace [OLE/DB Provider 'ADsDSOObject' ICommandPrepare::Prepare returned 0x80040e14]. ...
    (microsoft.public.data.oledb)
  • 0x80004005 - you need permission to view its data
    ... I have created a linked server to an Access97 database. ... If I am logged onto the sql server machine I ... OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error. ... OLE DB error trace [OLE/DB Provider 'Microsoft.Jet.OLEDB.4.0' ...
    (microsoft.public.sqlserver.security)
  • RE: OLE DB to Active Directory from SQL 2000
    ... An error occurred while preparing a query for execution against OLE DB provider 'ADsDSOObject'. ... OLE DB error trace [OLE/DB Provider 'ADsDSOObject' ICommandPrepare::Prepare returned 0x80040e14]. ...
    (microsoft.public.data.oledb)