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 |
|
tiamiyu
Starting Member
10 Posts |
 Posted - 2003-11-14 : 14:59:54
|
| We just changed the sa password and since them non of our DTS packages can be opened or executedIt comes back with the message "Login failed for user sa"Any hint on how to fix this will be appreciatedThanks |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-11-14 : 15:09:58
|
| You could change the sa password back, then go into your DTS packages and save them with a different account, then change the sa password.You might be able to change the owner_sid column in msdb.dbo.sysdtspackages so that it doesn't use the sa account. That table is where the DTS package is stored.I recommend not using the sa account when you save your packages, so you do not encounter this problem again.Tara |
 |
|
|
tiamiyu
Starting Member
10 Posts |
Posted - 2003-11-14 : 15:25:42
|
| For some reasons, each time I tried to save the DTS with another username, the system automatically set it back to sa. That was first thing I tried to do but it is not headin me anywhere.... |
|
|
|
|
|
|
DTS Could not open or execute