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

Re: Accessing ADLDS db through SQL Server

X-Received	by 2002:a0c:c702:: with SMTP id w2mr5914117qvi.248.1596229914522; Fri, 31 Jul 2020 14:11:54 -0700 (PDT)
X-Received	by 2002:a4a:ea29:: with SMTP id y9mr4702278ood.72.1596229914253; Fri, 31 Jul 2020 14:11:54 -0700 (PDT)
Path	csiph.com!xmission!news.alt.net!feeder.usenetexpress.com!tr1.iad1.usenetexpress.com!border1.nntp.dca1.giganews.com!nntp.giganews.com!news-out.google.com!nntp.google.com!postnews.google.com!google-groups.googlegroups.com!not-for-mail
Newsgroups	comp.databases.ms-sqlserver
Date	Fri, 31 Jul 2020 14:11:53 -0700 (PDT)
In-Reply-To	<XnsABFA7D084A264graynoibisspamcsumas@216.166.97.131>
Complaints-To	groups-abuse@google.com
Injection-Info	google-groups.googlegroups.com; posting-host=73.97.153.149; posting-account=wONEoQoAAACCyz0FOKwJytEmUgGJmt8l
NNTP-Posting-Host	73.97.153.149
References	<XnsABFA7D084A264graynoibisspamcsumas@216.166.97.131>
User-Agent	G2/1.0
MIME-Version	1.0
Message-ID	<aac2bdb0-df27-4a35-b15d-a1a079e64d21n@googlegroups.com> (permalink)
Subject	Re: Accessing ADLDS db through SQL Server
From	Tito <yosiasz@gmail.com>
Injection-Date	Fri, 31 Jul 2020 21:11:54 +0000
Content-Type	text/plain; charset="UTF-8"
Lines	38
Xref	csiph.com comp.databases.ms-sqlserver:2066

Show key headers only | View raw

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