Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  Import/Export (DTS) and Replication (2000)  LDAP and DTS

Author  Topic  pjc Starting Member 7 Posts Posted - 2006-07-27 : 11:59:33 I am a long time lurker and first time poster on this site. Here's my problem. I have an ActiveX script task that runs a query to pull users from a SQL Server table and then create the users in Active Directory. This script is the only item in the DTS package. The package runs perfectly from my machine, however I want this package to be kicked off by a stored procedure. I have the stored procedure set up and it tries to run the package, but it fails on the LDAP connection with "permission denied". From what I gather this is because it is trying to use the username logged in to SQL Server Agent. My main quesion: is there a way to specify which username and password to use for the LDAP connection? My LDAP connection in the script is: LDAP://ou=AST,dc=MYDC,dc=ABC We don't really want to give access to Active Directory to the SQL Server Agent account. This is my first experience using LDAP, so if you need more info, I will do my best to provide. Also, this is a clustered server if it makes any difference. Thanks, Pete