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

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

Re: Accessing ADLDS db through SQL Server

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