服务器修改sql server sa密码和administrator密码后,数据库维护计划中的数据库备份无法自动执行。手动运行后出现下面的错误提示:日期 2013-11-1 1:09:00
日志 作业历史记录 (ztjk_backup)步骤 ID 1
服务器 YOUR-048385A9ED
作业名称 ztjk_backup
步骤名称 子计划
持续时间 00:00:01
SQL 严重性 0
SQL 消息 ID 0
已通过电子邮件通知的操作员
已通过网络发送通知的操作员
已通过寻呼通知的操作员
重试次数 0消息
Executed as user: YOUR-048385A9ED\SYSTEM. ....3042.00 for 64-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 1:09:00 AM Error: 2013-11-01 01:09:00.95 Code: 0xC00291EC Source: {1C6F8C1C-FBAF-46A5-91D1-E38BFF405FA8} Execute SQL Task Description: Failed to acquire connection "???????". Connection may not be configured correctly or you may not have the right permissions on this connection. End Error Warning: 2013-11-01 01:09:00.95 Code: 0x80019002 Source: OnPreExecute Description: SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED. The Execution method succeeded, but the number of errors raised (1) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors. End Warning Error: 2013-11-01 01:09:01.17 Code: 0xC0024104 Source: ?????????? Description: The Execute me... The package execution fa... The step failed.请高人帮忙给看一看如何解决。谢谢!数据库修改密码备份失败
日志 作业历史记录 (ztjk_backup)步骤 ID 1
服务器 YOUR-048385A9ED
作业名称 ztjk_backup
步骤名称 子计划
持续时间 00:00:01
SQL 严重性 0
SQL 消息 ID 0
已通过电子邮件通知的操作员
已通过网络发送通知的操作员
已通过寻呼通知的操作员
重试次数 0消息
Executed as user: YOUR-048385A9ED\SYSTEM. ....3042.00 for 64-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 1:09:00 AM Error: 2013-11-01 01:09:00.95 Code: 0xC00291EC Source: {1C6F8C1C-FBAF-46A5-91D1-E38BFF405FA8} Execute SQL Task Description: Failed to acquire connection "???????". Connection may not be configured correctly or you may not have the right permissions on this connection. End Error Warning: 2013-11-01 01:09:00.95 Code: 0x80019002 Source: OnPreExecute Description: SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED. The Execution method succeeded, but the number of errors raised (1) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors. End Warning Error: 2013-11-01 01:09:01.17 Code: 0xC0024104 Source: ?????????? Description: The Execute me... The package execution fa... The step failed.请高人帮忙给看一看如何解决。谢谢!数据库修改密码备份失败
-->登录-->修改账户为Administrator,输入新密码.然后重启SQL Server服务.