May 1, 2012 at 1:24 pm
Does the account I create a proxy from need to have a password that doesn't change?
I created a proxy with credentials from my own account (password changes every 30 days, enforced by the system). Now of course I get errors on my sql agent jobs because I had to change passwords. Or am I doing something else wrong? Thanks for any insight.
May 1, 2012 at 4:26 pm
Dale Lanz (5/1/2012)
Does the account I create a proxy from need to have a password that doesn't change?
From BOL (http://msdn.microsoft.com/en-us/library/ms189064(v=sql.100).aspx):
"A proxy provides SQL Server Agent with access to the security credentials for a Microsoft Windows user."
If password change is enforced by your system, you need to make sure you change it in the proxy settings. A no password change account would be preferable to have the jobs run forever. 🙂
Or am I doing something else wrong? Thanks for any insight.
No, this is the standard behavior for proxies.
"El" Jerry.
May 1, 2012 at 6:14 pm
Thanks El, I have asked my domain admin for an account with no password change to use as a proxy.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply