Groups > comp.databases.ms-sqlserver > #2067

Re: Accessing ADLDS db through SQL Server

Path	csiph.com!xmission!news.alt.net!feeder.usenetexpress.com!tr2.iad1.usenetexpress.com!border1.nntp.dca1.giganews.com!nntp.giganews.com!buffer1.nntp.dca1.giganews.com!buffer2.nntp.dca1.giganews.com!news.giganews.com.POSTED!not-for-mail
NNTP-Posting-Date	Fri, 31 Jul 2020 18:53:51 -0500
Newsgroups	comp.databases.ms-sqlserver
Subject	Re: Accessing ADLDS db through SQL Server
From	"Lyle H. Gray" <lylefitzw@no.spam.gmail.com.invalid>
References	<XnsABFA7D084A264graynoibisspamcsumas@216.166.97.131> <aac2bdb0-df27-4a35-b15d-a1a079e64d21n@googlegroups.com>
Message-ID	<XnsAC0BCA68144ACgraynoibisspamcsumas@216.166.97.131> (permalink)
User-Agent	Xnews/2009.05.01
Date	Fri, 31 Jul 2020 18:53:51 -0500
Lines	48
X-Usenet-Provider	http://www.giganews.com
X-Trace	sv3-kXjH72rsMduXwP01joPCMEk0fjymw1fRqXUst06wfz4+0StDMuZ3UDZqjXEn4k3/f2ZzlHUGDiviWkG!53t4GM6J4FjH4UKfUbmQme0o+vz00XB9gYroAVewCtCPIC3npYplcOklAUFn8r3FCLhFJz8gzkPg!D0mJ61Wl
X-Complaints-To	abuse@giganews.com
X-DMCA-Notifications	http://www.giganews.com/info/dmca.html
X-Abuse-and-DMCA-Info	Please be sure to forward a copy of ALL headers
X-Abuse-and-DMCA-Info	Otherwise we will be unable to process your complaint properly
X-Postfilter	1.3.40
X-Original-Bytes	3077
Xref	csiph.com comp.databases.ms-sqlserver:2067

Show key headers only | View raw

Yes, the linked server works when I use Test Connection.

Tito <yosiasz@gmail.com> wrote in
news:aac2bdb0-df27-4a35-b15d-a1a079e64d21n@googlegroups.com: 

> The ADSI linked server is created and works when you right click on it
> and select Test Connection? 
> 
> On Tuesday, July 14, 2020 at 9:17:35 AM UTC-7, Lyle H. Gray wrote:
>> I have an Active Directory (LDAP) database, specifically AD LDS, that
>> stores information for a webserver on the same host. I have been
>> attempting to access this server through Transact-SQL, but am
>> currently blocked by the error: 
>> 
>> Msg 7330, Level 16, State 2, Line 3 
>> Cannot fetch a row from OLE DB provider "ADSDSOObject" for linked
>> server "ADSI". 
>> 
>> Note that this is not an AD database to store typical user
>> information for authentication, and that it does not have a DC entry
>> at the top level; it uses "O=[orgname],C=US" at the top level instead
>> for the connection that I'm trying to query. 
>> 
>> I have a Linked Server defined with the name "ADSI" using the
>> ADSDSOObject provider, and have tried using the following query to
>> attempt to retrieve information from the AD database: 
>> 
>> SELECT name 
>> FROM OPENQUERY(ADSI, 
>> 'SELECT name FROM ''LDAP://localhost:389/O=[orgname],C=US'' 
>> WHERE objectClass = ''person''') 
>> AS ldap_qry ; 
>> In this particular database, there are only 6 entries with
>> objectClass of 'person'. 
>> 
>> I'm using the current login's security context, which should have
>> access to the database (and I do not get an error related to
>> permissions). If I switch to an AD database that is used for
>> authentication (and uses DC= [orgname],DC=net), I am able to access
>> the information. 
>> 
>> The error message is not particularly useful, and all of the
>> information that I've found on this particular error reference the
>> limit on how many rows can be returned (which is a lot higher than 6
>> rows). 
>> 
>> Does anyone have any suggestions?

Back to comp.databases.ms-sqlserver | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

Accessing ADLDS db through SQL Server "Lyle H. Gray" <lylefitzw@no.spam.gmail.com.invalid> - 2020-07-14 11:17 -0500
  Re: Accessing ADLDS db through SQL Server Tito <yosiasz@gmail.com> - 2020-07-31 14:11 -0700
    Re: Accessing ADLDS db through SQL Server "Lyle H. Gray" <lylefitzw@no.spam.gmail.com.invalid> - 2020-07-31 18:53 -0500
      Re: Accessing ADLDS db through SQL Server Tito <yosiasz@gmail.com> - 2020-08-01 08:58 -0700
        Re: Accessing ADLDS db through SQL Server "Lyle H. Gray" <lylefitzw@no.spam.gmail.com.invalid> - 2020-08-01 12:04 -0500
          Re: Accessing ADLDS db through SQL Server Tito <yosiasz@gmail.com> - 2020-08-01 11:57 -0700
            Re: Accessing ADLDS db through SQL Server "Lyle H. Gray" <lylefitzw@no.spam.gmail.com.invalid> - 2020-08-01 21:11 -0500
            Re: Accessing ADLDS db through SQL Server "Lyle H. Gray" <lylefitzw@no.spam.gmail.com.invalid> - 2020-08-03 18:57 -0500

csiph-web