RE: ADAM AND ASP.NET

Your configuration shows that B and C are similar so the query must work for
C too. Where have you saved AZMan stores on B and C? Is it in Active
Directory or as an xml file? Have you tested running sql as domain admi?, it
may work. Which users have you set as Policy Administrators for Azman on B
and C?

Reza.

"fhillipo" wrote:

> I configured 3 machines on the same domain
>
> A
> Windows 2000 Server
> SQL Server
> IIS
> ASP.Net
>
> B
> Windows XP
> ADAM
>
> C
> Windows XP
> ADAM
>
> From machine A I can successfully execute the following query to return
> data from ADAM instance on B or C, using Query Analyzer (having configured a
> linked server)
>
> SELECT *
> FROM
> OPENQUERY(ADSI,'<LDAP://machineB:389/O=xxx,C=UK>;((OBJECTCLASS=*));EMPLOYEEID,NAME,TITLE,GIVENNAME,INITIALS, SN,TelephoneNumber;SUBTREE')
>
> or
>
> SELECT *
> FROM
> OPENQUERY(ADSI,'<LDAP://machineC:389/O=xxx,C=UK>;((OBJECTCLASS=*));EMPLOYEEID,NAME,TITLE,GIVENNAME,INITIALS, SN,TelephoneNumber;SUBTREE')
>
>
> From the front end using the web server on machineA I can run all reports,
> including the reports that use the above query, accessing ADAM on machineB.
> However if I alter the stored procedures to use machineC I get the following
> error:
>
> OLE DB provider 'ADSDSOObject' reported an error. The provider indicates
> that the user did not have the permission to perform the operation.
>
> Additional Information:
>
> SQL server runs within the context of a domain user with local and domain
> admin rights
> The said domain user has been added as a windows account in ADAM (as a
> Reader within Roles), so have 'service' and 'system' accounts
>
> Any clues greatly appreciated
> --
> fhillipo
.

Relevant Pages

  • ADAM AND ASP.NET
    ... I configured 3 machines on the same domain ... Windows 2000 Server ... ADAM ...
    (microsoft.public.windows.server.active_directory)
  • Re: ADAM as a Linked Server
    ... The Windows user account has sa server role within SQL ... > privileges to read data in this ADAM instance. ... From a SQLServer_A I can query the ...
    (microsoft.public.windows.server.active_directory)
  • Re: Server Buffers Are Full
    ... Does it consistently occur on the same machines? ... Does rebooting help the error? ... It appears that the client or the server maybe requesting too much data ... I'm running this query on a bunch of servers to figure out the start ...
    (microsoft.public.win32.programmer.wmi)
  • Identify fully qualified network name on xp home machine
    ... I've set up a DNS server on windows 2003 standard server. ... When I attempt the same query from a XP home machine it fails unless I ... suffixes the machines domain name to your query and then sends it to ...
    (microsoft.public.windows.server.dns)
  • Re: Very slow access using MDAC2.8
    ... > Would it be possible to locate the stored proc on the machines with the ... > same server too.) ... > resolve the query itself, and thus must read a large number of rows from the ... > either waiting on the query processor, ...
    (microsoft.public.data.ado)