Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 SSIS and Import/Export (2008)
 ssis job fail after windows account password chang

Author  Topic 

shilpash
Posting Yak Master

103 Posts

Posted - 2013-08-19 : 13:33:06
I have all the jobs running under proxy account and all of a sudden my windows domain account password needs to be chnaged.After the password changed,all the sql jobs failed.I cannot use the same password for my account under password credentials.Please help me to correct this issue.Thank you all

yosiasz
Master Smack Fu Yak Hacker

1635 Posts

Posted - 2013-08-27 : 23:23:13
what is the error you are seeing. why are you using your windows domain account, why not use another service account, or run all of your ssis packages using the default sql server service account it is running as

<><><><><><><><><><><><><><><><><>
If you don't have the passion to help people, you have no passion
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-08-28 : 03:28:27
if you're using proxy account to run package it shouldnt fail if you change password for your account. Is package trying to connect to any of the local servers? Otherwise so far as there's no change in proxy account, it should work as before

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page
   

- Advertisement -