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

Error authenticating proxy Expand / Collapse
Author
Message
Posted Thursday, March 28, 2013 3:52 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, July 17, 2014 8:54 AM
Points: 18, Visits: 118
Hi,
I've got a SQL Server 2008 job which ran ok yesterday but has fail today with an error message ' Error authenticating proxy'. The only thing that has changed bewteen the two runs is my Windows AD password. I thought the report had been set up to use a generic password we have that doesn't change but I must be wrong.

Question 1. I need to get this report to run but I don't know where to look in SSMS to correct the password.
Question 2. How do I amend the job so that it uses the generice password and I don't get this problem next month.

Many thanks for any help

Stuart.
Post #1436351
Posted Tuesday, April 2, 2013 5:51 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, October 31, 2013 3:44 AM
Points: 314, Visits: 4,128
ssmith 29602 (3/28/2013)
Hi,
I've got a SQL Server 2008 job which ran ok yesterday but has fail today with an error message ' Error authenticating proxy'. The only thing that has changed bewteen the two runs is my Windows AD password. I thought the report had been set up to use a generic password we have that doesn't change but I must be wrong.

Question 1. I need to get this report to run but I don't know where to look in SSMS to correct the password.
Question 2. How do I amend the job so that it uses the generice password and I don't get this problem next month.

Many thanks for any help

Stuart.


I am assuming the Job in question is based on a Proxy?
Post #1437844
Posted Wednesday, April 3, 2013 9:44 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, July 28, 2014 4:11 AM
Points: 182, Visits: 344
Go to SQL Server Agent > Proxies and check each container there if one has a proxy account set there. find and change the password. To fix it permanently, use some service account with no password expiration and document it as dependency so that when you reset the password for this account, you know where are the effects.
Post #1438444
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse