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
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Wednesday, July 1, 2015 9:37 AM
Points: 644, Visits: 2,441
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


SSC-Addicted

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

Group: General Forum Members
Last Login: Wednesday, June 24, 2015 8:56 AM
Points: 447, Visits: 275
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