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.
| Author |
Topic |
|
PaulMoxon
Starting Member
5 Posts |
 Posted - 2009-07-16 : 11:23:24
|
| ** sorry of this is the wrong forum **One of our coders is getting the Error string: login failure for the following bit of code.SET @dts = 'dtsrun /S "NMOBID01" /U "Domain\Username" /P "password" /N "Load Referrals HSW RL1 V3" /M 'If I change the script to use an SQL login it works fine on the instigating server but fails to do its work on the target server (access denied) at dts datapumptask2. The domain account mentioned above has been added in to the local admin group on both servers, so in theory it should not be a permission issue server side. |
|
|
|
|
|
DTS Error String: Login Failure.