Hi all, I have been knocking my head against this one for a few days -- haven't been able to find a solution to this anywhere so hopefully someone can help.
Situation: A really simple LDAP that searches for a users AD account - it works for some users, not for others. More bizarrely, for some people it seems to work occassionally.
Setup: This is an internal intranet. ASP pages are served from IIS 6 on a WIN 2003 Server box. Annon Access is OFF, Integrated and Basic directory security is ON. Active Directory is on another Win Server 2003 domain controller. The IIS box is 'trusted for delegation'.
In active directory we have all our employees set up with employee numbers. All I am doing is searching for the user with their WINNT login full name. (ie, from adsUser.get("FullName")). Before you ask - I have checked that the FullName returns exactly the same thing as appears as the AD users display name.
So, the query goes as follows:
<LDAP://ou=Support Centre Users,dc=mydomaincontroller,dc=co,dc=nz>;((&(objec tCategory=person)(objectClass=user)(cn=Some Users Name));cn,employeeNumber;subtree
Now - here's the wierdness - if [b]I[b] go to the page with this query I get a 'Table does not exist' error. If someone else in my same OU (with the same group policy, permissions, etc) goes there it works fine and returns their cn and employee number. Certain other users get an error, the rest it works find every time.
Now SOMETIMES when I go to the page it works, but mostly it doesn't. There were no modifications made to the script or to AD in that time.
Anyway have any ideas where to look?