asked
Running SSIS jobs with AD account
I am currently running SSIS jobs using my user ID that is defined by Active Directory and I have utilized the Proxy and Credentials as described in one of the SqlServerCentral articles. The jobs touch at least 2 different physical servers. My concern is that I am required to change my password every 90 days which can cause the jobs to fail until I go through and change the password on the Identity (my AD account) associated with the Proxy. Is there a better method than this? I am still learning so any help would be greatly appreciated. Thank you. - William
Are you able to have a user set up whose creds do not expire? Give that user access to only the parts on each server that need to be touched (files/applications) and lock down everything else. Sounds like you have a business case for it if your network admins don't like that idea.
Thank you @SQLShark, Current security protocols do not allow the creation of an account with a non-expiring password, but I am taking your suggestion and asking if there is an allowance if I can provide a business case showing the need. Thank you. - William
15 People are following this question.
