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.
| Author |
Topic |
|
Vivaldi
Constraint Violating Yak Guru
298 Posts |
 Posted - 2006-02-14 : 10:28:32
|
| I am looking into changing our SQL system accounts more frequently.We save our DTS pkg's with Windows Auth. Our jobs all use a specific windows domain account as the owner of the jobs.If we were to change the windows acct password via the network admin, what is the affect on the jobs? Does each job store the domain acct password? I have done a bit of reading, but nothing that talks about this in any detail? any thoughts?________________________________________________The only cure for thinking is picking rocks, or drinking beer. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-02-14 : 13:22:29
|
| The jobs do not store passwords. It gets this information from the MSSQLSERVER service. So make sure that you change the password after it is changed for the userid.Tara Kizeraka tduggan |
 |
|
|
Vivaldi
Constraint Violating Yak Guru
298 Posts |
Posted - 2006-02-14 : 13:32:40
|
quote:
Originally posted by tkizer
The jobs do not store passwords. It gets this information from the MSSQLSERVER service. So make sure that you change the password after it is changed for the userid.Tara Kizeraka tduggan
Thanks, happened to find something buy Tibor Karazi (spelling?) that mentioned that. Good to know that just the agent pwd is the place to worry about it.Does the challenge/response happen each time the agent invokes a job, or is it cached until a refresh happens or the agent is restarted??________________________________________________The only cure for thinking is picking rocks, or drinking beer. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-02-14 : 13:37:48
|
| I'm not sure.Make sure to change both the MSSQLSERVER and SQLSERVERAGENT services!Tara Kizeraka tduggan |
|
|
|
|
|
|
Password Changing Policies