I need to create a Crystal Report that will access Active Directory but will run on a machine outside of the domain. The machine resides in a different domain but within the same LAN as the target domain.
When I try to set the ADSI connection, I get the "table does not exist" error in response to the LDAP query. Therefore, I assume that I am not authenticating and establishing the connection to ADSI. I can't use integrated authentication since the machine is not logged into that domain. I am providing a user that has sufficient rights and the user's password in the connection setup in the report. I've tried the target computer's IP address as well as the fully qualified name for the connection's data source parameter, both of which result in the same error message. I am also passing the qualified name of the user as well.
I assume I could set up a trust between the domains so that I could use integrated authentication, although I haven't tested that. However, doing so will create more security and auditing issues that I want to avoid, especially since this isn't the only domain against which I'll have to report. The best scenario would be getting the connection set properly from within the report so that it can be scheduled on CR Server.