Accessing ADLDS db through SQL Server

28 views
Skip to first unread message

Lyle H. Gray

unread,
Jul 14, 2020, 12:17:35 PM7/14/20
to
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?

Tito

unread,
Jul 31, 2020, 5:11:56 PM7/31/20
to
The ADSI linked server is created and works when you right click on it and select Test Connection?

Lyle H. Gray

unread,
Jul 31, 2020, 7:53:58 PM7/31/20
to
Yes, the linked server works when I use Test Connection.

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

Tito

unread,
Aug 1, 2020, 11:58:43 AM8/1/20
to
I believe your error is due to the fact that you might have more than 6 for that specific filter? Are you sure you only have 6 people that match that filter?

Lyle H. Gray

unread,
Aug 1, 2020, 1:04:22 PM8/1/20
to
Tito <yos...@gmail.com> wrote in
news:03de176c-c2fb-478e...@googlegroups.com:

> I believe your error is due to the fact that you might have more than
> 6 for that specific filter? Are you sure you only have 6 people that
> match that filter?

I am very sure that I only have 6 for that specific filter.

Tito

unread,
Aug 1, 2020, 2:57:54 PM8/1/20
to
This is what I have in case it helps

where objectClass = ''User''
AND objectCategory = ''Person''
AND ''userAccountControl:1.2.840.113556.1.4.803:'' <>2 ')

Lyle H. Gray

unread,
Aug 1, 2020, 10:11:22 PM8/1/20
to
I'll have to see if this fits into my situation on Monday. Thank you for
the suggestion.

Tito <yos...@gmail.com> wrote in
news:b000045a-5226-4f88...@googlegroups.com:

Lyle H. Gray

unread,
Aug 3, 2020, 7:57:58 PM8/3/20
to
It doesn't look like this approach makes any difference in my case. I
still get the [uninformative] error.

But thanks again for the suggestion.

Tito <yos...@gmail.com> wrote in
news:b000045a-5226-4f88...@googlegroups.com:
Reply all
Reply to author
Forward
0 new messages