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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2000-10-26 : 17:56:13
|
Pat writes "SQL agent fails to run my DTS job:
WINNT sp4, SQL 7 sp 2 installed
The job history shows this error:
DTSRun: Loading... Error: -2147217843 (80040E4D); Provider Error: 18456 (4818) Error string: Login failed for user '\'. Error source: Microsoft OLE DB Provider for SQL Server Help file: Help context: 0. Process Exit Code 1. The step failed.
I have changed the owner of the Job to be the system admin. Other DTS packages are running satisfactorily. The DTS executes with no problems by it self.
So I tried to reset the options for the SQL agent with these results:
Reset Proxy Account >>>
Unable to install the SQL Server Agent proxy account(SQLAgentCmdExec). Job steps of type CmdExec or ActiveScripting of jobs owned ny non-sysadmins will not run correctly.
Reset Proxy Password >>>
The user name could not be found.
Restarting SQL Agent: >>>>
[000] Unable to access the password for the 'SQLAgentCmdExec'
proxy account (reason: Access is denied)
DTSRun: Loading... Error: -2147024809 (80070057); Provider Error:" |
|
|
|
|
|
SQL agent failing