Last post Apr 17, 2008 01:14 PM by lantonio1974
Apr 09, 2008 11:22 AM|lantonio1974|LINK
I am trying to run aquery on a local server I recently got for development. I am trying the next query but keep getting the err that could no find server ADSI in sys. servers.
'SELECT Name, SN, ST, mobile, ipphone, mail, displayName, telephoneNumber, initials, title, department, homePhone, manager, sAMAccountName, MSnpAllowDialIn, employeeId
FROM ''LDAP://DC=namelocal, DC=local''
WHERE objectCategory = ''Person'' AND objectClass = ''
I try to added as a liked server but it didn't work. I try this same query on another computer with current domain name and is working. Any idea what I am doing wrong?
Apr 17, 2008 07:21 AM|johram|LINK
You will need a linked server with explicit credentials. What error message do you get when you try to add it?
this article might be helpful to you.
Apr 17, 2008 12:53 PM|lantonio1974|LINK
I try adding credentials but still not getting to query AD.
FROM ''LDAP://CN=users,DC=domain,DC=org, uid, pass''
Apr 17, 2008 01:14 PM|lantonio1974|LINK
Thanks for that article. I got working now, what I just need is to know how to add the uid and pass.