Hello --
I'm trying to get SQL Server 2000 on a Windows 2000 Server to be able
to query an Active Directory. We've got two domain servers one Win2000
and one Win2003. However, I'm having problems:
I've run the following query to setup the linked server:
sp_addlinkedserver 'ADSI', 'Active Directory Service Interfaces',
'ADSDSOObject', 'adsdatasource'
Using Enterprise Manager I've changed the login details for the ADSI
linked server to:
Be made using the following security context:
Username: MyDomain\Administrator
Password: ****
I've then tried to run the following query in Query Analyzer:
SELECT * FROM
OpenQuery(
ADSI,
'<LDAP://CN=Users,DC=MyDomain,DC=com>;(&(objectCategory=Per son)(objectClass=User));name,adspath'
)
But get the following error message:
Could not execute query against OLE DB provider 'ADSDSOObject'.
Does anyone have any ideas on what this message means or how to get
this working?
Thanks
--
James Allan
james [at] allan-home.co.uk