ADAM AND ASP.NET

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

  • Re: Fileserver question
    ... >> another box running both 9.0 and Windows. ... >> computers in the same room and connected to a router. ... otherwise you will need to run a DHCP server on one ... > of the machines, preferably the server, or give both machines static ...
    (alt.os.linux.suse)
  • nslookup times out on some WinXP clients
    ... Basically, nslookup times out on some Windows machines, but not on others. ... we currently have a Windows 2000 Server DNS & DHCP Server serving IP ...
    (RedHat)
  • Re: New: LanMan98 V2 Not connecting
    ... all) Windows machines, the computer name as found in the system ... essentially Windows was rejecting the connection because it hadn't ... LanMan98 appears to be one, ... uses a low-level message protocol called SMB (Server Message Block). ...
    (comp.sys.acorn.networking)
  • Re: DST Updates - fun, fun
    ... Most XP machines received the daylight savingtimeupdate ... thesystemtimeis jumping ahead an additional ... all Windows XP, sp2 computers have been patched and verified. ... all Windows 2003 Server machines ...
    (microsoft.public.windowsxp.general)
  • Re: DST Updates - fun, fun
    ... Most XP machines received the daylight savingtimeupdate ... all Windows XP, sp2 computers have been patched and verified. ... all Windows 2003 Server machines ... All patches applied. ...
    (microsoft.public.windowsxp.general)