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 |
|
luzippu
Starting Member
23 Posts |
 Posted - 2006-09-27 : 11:12:55
|
| MS SQL Server 2005i get the following error when trying to run this job as user1:'Unable to start execution of step 1 (reason: Error authenticating proxy serv1\user1, system error: Logon failure: unknown user name or bad password.). The step failed.'and the following error when trying to run the same job as 'sql agent service account':'Executed as user: serv1\user1. The process could not be created for step 1 of job 0x3653ACCFFA46DD47B3703C87DDFD0717 (reason: 2). The step failed.'>job:job name: job1server: (local)connection: net1\user1owner: serv1\user1step type: operating system (cmdexec)run as: user1command:@echo off copy C:\test.txt C:\folder ECHO Job completed PAUSE>the sql server agent service is running under 'serv1\user1' and works fine for other jobs running ssis packages.>i have created the following credentials under security/credentials:credential name: serv1\user1identity: serv1\user1password: same as sql server agent service>i have created a proxy under the sql server agent/operating system (cmdexec):proxy name: user1credential name: serv1\user1active subsystem: operating system (cmdexec)principals (sql login): serv1\user1thank you |
|
|
luzippu
Starting Member
23 Posts |
Posted - 2006-09-28 : 08:50:39
|
| found the problem.the 'pause' at the end of the cmd was pausing the running step. |
 |
|
|
tpkhoa
Starting Member
1 Post |
Posted - 2010-01-26 : 00:06:06
|
| Hi luzippu and all,I have a problem that I create a SQL job like your, but when the job stared, the message in echo command not show in command line screen ( this screen not display in desktop). but this job was successfully.What did I wrong?Please help me. |
|
|
|
|
|
|
Run batch file in a job step.