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 |
|
dpais
Yak Posting Veteran
60 Posts |
 Posted - 2009-02-20 : 13:52:57
|
| Hello : I would like to change the password in user 'SA' ... what are the implications to that I have numerous DTS packages that are connected with the SA username and password ( meaning the connections donot use windows authentication) I have actually checked the box for SQl server authentication and typed in SQ and password to make the connection.Will SQL server tell the DTS package to automaically use the new password ... also are there any other things to lookout for when i change the SA password ?thanks. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
dpais
Yak Posting Veteran
60 Posts |
Posted - 2009-02-23 : 09:08:31
|
| Thanks Tara : I will do the necesssary analysis before I continue. |
 |
|
|
|
|
|
Implications of password change for 'SA' in 2000