Fixing permissions for SQL Jobs
Posted on 2009-05-08
Below is there error message I get when trying to run a SQL Job. I have an idea of what the problem is but can seem to find the palce to change the username and password.
I am trying to run a legacy DTS package in a scheduled job but the job fails due to an invalid password. I checked the server configuration Manager and Surface Area Configuration but the account in the error message below is not listed as the SQL Server Agent account.
I'm running SQL Server 2005 and I have my SQL Agent setup to run as a domain admin account instead of the default local service. Everything worked fine until this morning when the domain admin account password expired and I had to change it. I'd like to change the domain acount that is used by SQL server but I can find where to change the account and password.
Date 5/8/2009 10:36:58 AM
Log Job History (Job Name)
Step ID 1
Job Name Job name
Step Name Execute DTS
Sql Severity 0
Sql Message ID 0
Operator Net sent
Retries Attempted 0
Unable to start execution of step 1 (reason: Error authenticating proxy Domain\User, system error: Logon failure: unknown user name or bad password.). The step failed.