|
Home > Archive > MS SQL Server Connectivity > June 2005 > Problems linking up SQL Server and ADSI
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Problems linking up SQL Server and ADSI
|
|
| 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
| |
| Sue Hoegemeier 2005-06-08, 7:23 am |
| One possibility is that you can get the error if the service
account for SQL Server is not a member of Readers in ADAM.
-Sue
On Tue, 7 Jun 2005 22:34:31 -0700, "Klaus Salchner"
<klaus.salchner@telus.net> wrote:
>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
>
|
|
|
|
|