| Author |
Topic |
|
Kricky
Starting Member
4 Posts |
 Posted - 2003-08-06 : 12:31:10
|
| We had to change the passwords on our SQL servers. I noticed that the jobs we have set up on one of our servers are failing because of this. How can I change the password for these jobs? I am able to do it in the DTS packages, but the jobs are still showing as a fail status.Thanks,K |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-08-06 : 12:53:30
|
| Jobs do not have passwords, but job steps could. If you did the job step yourself, you will need to edit the DTSRUN command. If you scheduled the DTS package using the wizard, then you will need to do that again as it put the password in the command.Tara |
 |
|
|
Kricky
Starting Member
4 Posts |
Posted - 2003-08-11 : 11:31:13
|
| I have rescheduled the job, but it still appears to be failing. I did not create the job or the package, the person that did, is not here anymore. It looks like she created it as a Job first and then added some more steps in the DTS Designer. Not sure how to proceed.Thanks,Kricky |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-08-11 : 12:25:42
|
quote:
Originally posted by Kricky
I have rescheduled the job, but it still appears to be failing. I did not create the job or the package, the person that did, is not here anymore. It looks like she created it as a Job first and then added some more steps in the DTS Designer. Not sure how to proceed.Thanks,Kricky
Did you look at the job steps yet? Did you look at the connection properties in the DTS package? All of these could have hard coded sa password.Tara |
|
|
|
Kricky
Starting Member
4 Posts |
Posted - 2003-08-11 : 13:28:32
|
| The 1 job step only says "DTSRun ... " with the encryption. I have already changed the passwords in the DTS connections to the new password... Not sure what else to do.Thanks,Kricky |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-08-11 : 13:35:15
|
| Open the package in the DTS Designer. Then go to Package, Save As... If it is using the sa account, modify the password. Then reschedule the package. Have you tried executing the package just by hitting the green arrow to execute it in DTS Designer? If it fails, it should indicate what part is failing.Tara |
|
|
|
jasper_smith
SQL Server MVP & SQLTeam MVY
846 Posts |
Posted - 2003-08-11 : 14:08:28
|
| Recreate the job e.g. right click job and choose schedule, it is [ossible that for whatever reason, the encrypted DTSRUN command is passing the sa username and password rahter than using Windows Authentication.HTHJasper Smith0x73656c6563742027546f6f206d7563682074696d65206f6e20796f75722068616e6473203f27 |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-08-11 : 14:12:41
|
quote:
Originally posted by jasper_smith
Recreate the job e.g. right click job and choose schedule, it is [ossible that for whatever reason, the encrypted DTSRUN command is passing the sa username and password rahter than using Windows Authentication.
Kricky already did that. But in order for it to have worked, the package would have had to be saved with the new sa password. So simply rescheduling the job won't work, you have to do save as and then specify the new password, then reschedule the job.Tara |
|
|
|
Kricky
Starting Member
4 Posts |
Posted - 2003-08-11 : 18:16:55
|
| Thanks. Finally got it to work. |
|
|
|
|
Change sa passwords