I'm using SQL 2005 and try to create a SQL Agent Job.
I have a stored procedure named SP_Test with only one select statement on the local database A. The stored procedure is created by user: pesa and pesa is the db_owner of database A.
Then I created a Job in SSMS using pesa account and set the Job owner as pesa and Run as user: pesa.
When I ran the Job inside SSMS with pesa account, I got the following error:
2010-02-24 11:30:01.43 Logon Error: 18456, Severity: 14, State: 8.
2010-02-24 11:30:01.43 Logon Login failed for user 'pesa'. [CLIENT: <local machine>]
I understand that State: 8 means 'Password mismatch'
. But I didn't enter any password when I ran the Job.
By the way, pesa is also a system admin account on the SQL 2005 server.
Any help is appreciated.
View Complete Post