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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-05-30 : 09:43:41
|
| Shay writes "HiI wrote afew scripts & stored procedures that backup adatabase on my production server and send it to astandby server. after the backup is copied to the standby server I fire astored procedure on the standby server which actually restores the database on the standby server.Yesterday I changed the password for sa and the last step (which fires the stored procedure on the standby server) fails. the message in the job history says:"Login failed for user sa".What should I do with schedueld jobs of sql server Agent after changing sa password ???Thanks." |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2002-05-30 : 10:11:28
|
| Does this mean you have a remote connection to the sandby server? If so you may want to check this.....PeaceRick |
 |
|
|
Kevin Snow
Posting Yak Master
149 Posts |
Posted - 2002-05-30 : 10:13:56
|
| IF you have the SQL AGENT running under a designated account, you may need to update the password. Check your SERVICES to see what account it is running under. |
|
|
|
|
|
|
Job fails after password changed for sa