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 |
|
meth73
Starting Member
10 Posts |
 Posted - 2007-12-27 : 03:36:17
|
| Bit puzzled with this at the moment. Tried quite a few combinations, but still can't get a DTS to run from a remote machine.I keep getting a 'login failed for user' type error.DTSRUN /Sserver /Uusername /Npackage ...(using SQL credentials). This same command (using an IP Address for the server) works on the local machine, but not on the remote machine. The SQLSERVERAGENT service is running under the ./Administrator account. I'm reluctant to change this at this stage unless there is no other way.I have also tried creating identical AD Accounts on both the local and remote servers (with local admin rights), then tried this login in the above command and it still failsAny pointers? Surely running this with SQL or AD admin accounts should do the job? There is only 1 connection in the DTS itself, which I have tried changing to both Windows/SQL Authentications types as per the SQL/AD credentials passed through the DTSRUN command.Thanks. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2007-12-27 : 03:50:35
|
think this might be of help:-http://forums.devarticles.com/microsoft-sql-server-5/remote-dts-3396.html |
 |
|
|
meth73
Starting Member
10 Posts |
Posted - 2007-12-27 : 04:16:20
|
| I checked out that URL already, googled a number of others without success and realised that I might have missed a detail - I need to execute this command (on the remote machine) from batch file / Windows Scheduler. Also worth mentioning is that I have tried 'runas' without success, and the environment (for both servers) is without a unified domain.TIA |
|
|
|
|
|
|
Help with DTSRUN