Problems linking up SQL Server and ADSI

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

  • link SQL Server with ADSI
    ... are running on the local machine. ... I created the link in SQL server using the "OLEDB Provider for Microsoft ... The security is set to "Be made without ... Klaus Salchner ...
    (microsoft.public.sqlserver.connect)
  • Re: SQL or Access DB
    ... As far as encryption goes though... ... with Sql Server you can use SQL DMO and encrypt your stored procedures ... installation - Security was absolutely critical and in most instances, ... > then we create a nice gui around this database and sell it to automotive ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Is there any way to prevent hacker trying to guess sa password?
    ... and port 1433 will not be open. ... If someone can crash SQL Server by connecting to port 1433, ... You don't need multiple security experts. ...
    (microsoft.public.sqlserver.security)
  • Re: Getting to the bottom of MSDE network connection problems ...
    ... Brilliant, Nick, especially the explanation for local network user being ... authenticated as GUEST in WinXP SP2. ... > on a desktop OS like XP (meaning that, you can not compare SQL Server ... > again and selected the security tab. ...
    (microsoft.public.sqlserver.msde)
  • [NT] SQL Extended Procedure Functions Contain Unchecked Buffers
    ... The following security advisory is sent to the securiteam mailing list, and can be found at the SecuriTeam web site: http://www.securiteam.com ... SQL Server 7.0 and 2000 provide extended stored procedures, ... Several of the Microsoft-provided extended stored procedures have been ... Exploiting the flaw could enable an attacker to either cause the SQL ...
    (Securiteam)