Linked Server to Active Directory

• Iris Palacios

  SSC Enthusiast

  Points: 127

  More actions

  February 25, 2005 at 1:02 pm

  #163707

  Hello,

  I'm trying to set up an active directory linked server and have executed the following procedure:

  EXEC sp_addlinkedserver 'ADSI', 'Active Directory Service Interfaces',

  'ADSDSOObject', 'adsdatasource'

  GO

  This created my linked server; however, when I try to access the data I receive an error 7301 stating the error "Could not obtain a required interface from OLE DB provider 'ADSDOObject'.  After reviewing various MS sites, it states that this interface is part of the OS.  The only download I could find for this provider is for a Novell System and I am currently running SQL Server 2000 on Windows 2003.

  Any ideas as to where I could find the OLE DB provider?

  thanks!

• noeld

  SSC Guru

  Points: 96590

  More actions

  February 25, 2005 at 1:20 pm

  #544256

  Have a look at this

  http://support.microsoft.com/default.aspx?scid=kb;en-us;299410

  http://www.microsoft.com/technet/scriptcenter/scripts/ad/computer/default.mspx

  http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adsi/adsi/distributed_query.asp

  
  * Noel