I have written a SSIS 2005 script task that connects to Active Directory and reads user accountnames to store in database. I was able to successfully test this on my local system by executing dtexec.exe cmd. However, when I try the same on the server, the ldap query times out. The same ldap query as a console application just works fine.
I m using .NET class: System.DirectoryServices.Protocols.LdapConnection and SendRequest to retrieve user account names.
Could you let me know if I m missing something?
Thanks!
=========
Update: I m actually getting "Ldap Server is unavailable" error. Still not sure, what might be causing this error.