question

william.demasi avatar image
william.demasi 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
ssispasswordproxy
2 comments
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

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.
1 Like 1 ·
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
0 Likes 0 ·

0 Answers

· Write an Answer

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.