Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

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

Re: Accessing ADLDS db through SQL Server

Show all headers | 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