March 28, 2013 at 3:52 am
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.
April 2, 2013 at 5:51 am
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?
April 3, 2013 at 9:44 am
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.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply