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
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Thursday, August 28, 2014 5:15 PM
Points: 522, Visits: 2,013
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: Wednesday, August 20, 2014 2:20 AM
Points: 386, Visits: 233
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