sql server 2016自动备份失败问题

Question

操作步骤：
1、创建用户a，初始密码b；
2、修改密码为c；
3、重新登录用户a，密码c成功；
4、创建自动备份维护计划成功；
5、右键维护计划-执行；
6、执行结果失败：用户名与密码不匹配，账户被锁定；
7、修改用户属性，密码改成初始密码b，并登录验证成功；
8、重新创建自动备份维护计划成功；
9、右键维护计划-执行；
10、执行结果成功；
疑问：
为什么修改密码后创建的自动备份执行失败？而改回初始密码就能执行成功？

Answer 1

This is an English spoken forum, so please post your question in English or to a localize forum.

Olaf

Answer 2

Hi,

After changing the password of the specific user, you also need to update the password in the connection settings of the maintenance plan, otherwise the maintenance plan will not work.

Modify or double click the maintenance plan to open it in design view. Then click on the Manage Connections drop down and select the Local server connection. Provide the user name and the new password, click OK and save the maintenance plan.Then the maintenance plan will now work again.

More details you can refer to this article.

===============================================
If the response helped, do "Accept Answer" and upvote it.