Re: Problems linking up SQL Server and ADSI

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

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@xxxxxxxxx> 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,'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@xxxxxxxxx
>
>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
>

.

Relevant Pages

  • Re: Problems running SQL Services under a not privileged user account
    ... SQL Server Agent should be running under Domain account (which is a member ... of Local Admin Group on SQL Server machine) ... > I created a local user account, member of the USER group and setup the SQL ...
    (microsoft.public.sqlserver.security)
  • Maintenance Plan Job fails - authentication failure
    ... is a member of the Local Administrators Group on the ... accessing SQL Server. ... The domain account that both SQL ...
    (microsoft.public.sqlserver.security)
  • RE: Installation Help
    ... If your smsservice account is a domain administrator, and the sql server ... is a domain member then everything should be fine. ... >> Administrators group of the SQL Server machine. ...
    (microsoft.public.sms.admin)
  • Re: Add Windows Security Principal as ADAM Admin via LDIFDE?
    ... if you add the member to the group with LDIFDE using the SID binding ... >> Backup a production ADAM instance and restore into a lab ... Access directory via LDIFDE ... >> In ADAM ADSI Edit when I add a Windows account to the Administrators ...
    (microsoft.public.windows.server.active_directory)
  • Re: Startup account in Domain Controller
    ... Running SQL Server on a domain controller isn't recommended ... The SQL Server service accounts ... account be a member of the administrators group, ...
    (microsoft.public.sqlserver.security)