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 |
|
nicole
Yak Posting Veteran
97 Posts |
 Posted - 2006-03-01 : 03:28:21
|
| For the DTS packages, I use server admin(sa) to connect to the SQL Server. If I changed the admin password, do I have to manually change the password for each DTS package? or they will be updated automatically? |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2006-03-01 : 03:32:34
|
| yes. the password is saved in the DTS package.----------------------------------'KH' |
 |
|
|
nicole
Yak Posting Veteran
97 Posts |
Posted - 2006-03-01 : 03:50:38
|
But I'm not sure if the password used in the DTS package will be updated automatically after the admin password is changed  |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2006-03-01 : 03:56:16
|
Nope. It is not update automatically. You have to manually changed this in the DTS package. Done this once, when i change the password  ----------------------------------'KH' |
|
|
|
nicole
Yak Posting Veteran
97 Posts |
Posted - 2006-03-01 : 04:12:46
|
oh, have to do it manually  that's horrible  |
|
|
|
|
|
|
DTS Connection