| Klaus Salchner 2005-06-08, 3:23 am |
| Hi,
I am trying to link up a SQL Server 2000 SP4 (or SP3a) with a ADAM (Active
Directory Application Mode) on Windows 2003 SP1. Both SQL Server and ADAM
are running on the local machine. The user I am logged on is a local
Administrator account.
Unfortunately with not much luck.
I created the link in SQL server using the "OLEDB Provider for Microsoft
Directry Services". I used as product name "Active Directory Services" and
as data source "adsdatasource". The security is set to "Be made without
using a security context". I tried any of the security settings with not
much luck.
When I run a query like SELECT * FROM OPENQUERY(ADSI,'SELE
CT cn FROM
''LDAP:// OU=SABA,CN=Vancouver
'' ') then I get the following error back
Server: Msg 7321, Level 16, State 2, Line 1
An error occurred while preparing a query for execution against OLE DB
provider 'ADsDSOObject'.
OLE DB error trace [OLE/DB Provider 'ADsDSOObject' ICommandPrepare::Pre
pare
returned 0x80040e14].
I have researched this issue quite a bit. There are people out where which
can make it work. But all postings I could find on this issue where not able
to resolve my issue.
Any help is appreciated
Regards, Klaus
-----------------------------------------------
Klaus Salchner
Sr. Enterprise Architect
www.enterprise-minds.com
email: klaus.salchner@telus.net
Proud member of
http://linkedin.com - become part of my professional network; it's a free
3rd party tool
http://gotdotnet.com
http://theserverside.net
|