DTS login problems

[BJJJB]

I'm trying to sort out and problem for an associate. Any help would be appreciated.

A command file, resident on the same server, runs the following script
dtsrun /SserverName /U\\Domain\UserName /Ppassword /NprogramName /G{4D63AAF5-EDAE-11D6-A314-002035C387A5} /V{4D63AAFF-EDAE-11D6-A314-002035C387A5}

This causes the following response:

DTSRun: Loading...

Error: -2147217843 (80040E4D); Provider Error: 18456 (4818)
Error string: Login failed for user '\\Domain\UserName'.
Error source: Microsoft OLE DB Provider for SQL Server
Help file:
Help context: 0


I've checked that the username exists as a user on the SQL system and tried it with and without the domain suffix. Get the same error.
If I sign on to the server as UserName and run the DTS job interactively it works just fine (i.e. NOT using the command file)

HELP!!
Thanks
BJJJB

 

[tlbroadbent]

When using NT authentication, don't put the user and password on the command line. Use the /E option to indicate a trusted connection. See "dtsrun utility" in SQL BOL for more options.

http://msdn.microsoft.com/library/en-us/coprompt/cp_dtsrun_95kp.asp

Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/programmer.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.