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,'SELECT 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::Prepare 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
