Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

job is failing Expand / Collapse
Author
Message
Posted Tuesday, January 21, 2014 2:01 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Yesterday @ 8:38 PM
Points: 492, Visits: 1,885
one of the job which is runing under proxy account is failing due to the password is expired , we changed the password in credentials and ran the job . still the job is failing .

we deleted the credential and proxy account and created inew credential and proxy , still having the same issue .

How to resolve ?
Post #1532905
Posted Tuesday, January 21, 2014 6:31 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Friday, April 11, 2014 1:53 AM
Points: 339, Visits: 211
Have you restarted either the instance or SQL Agent ? And confirmed that the proxy account still hase the requisite OS and SQL permissions ?

Maybe SQLAgent is running on cached credentials (ie the expired ones)...





sqlmunkee
Bringing joy and happiness via SQL Server since 1998
Post #1533018
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse