May 30, 2018 at 9:21 am
After our DBA left, I changed the password on his account per policy. The maintenance plans he set up now fail. The history log of the subplan is below with the actual server and user names redacted. Where is the password stored for this user so that I can change it?
Executed as user: DOMAIN\SERVER$. Microsoft (R) SQL Server Execute Package Utility Version 10.50.6560.0 for 64-bit Copyright (C) Microsoft Corporation 2010. All rights reserved.
Started: 11:13:51 AM Error: 2018-05-30 11:13:51.56 Code: 0xC00291EC Source: {43F60899-2946-44D5-B916-5948ECC83F78} Execute SQL Task
Description: Failed to acquire connection "Local server connection". Connection may not be configured correctly or you may not have the right permissions on this connection. End Error
Warning: 2018-05-30 11:13:51.56 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: 2018-05-30 11:13:51.58 Code: 0xC0024104 Source: Back Up Database Task
Description: The Execute method on the task returned error code 0x80131904 (Login failed for user 'USER.NAME'.). The Execute method must succeed, and indicate the result using an "out" parameter. End Error
Error: 2018-05-30 11:13:51.58 Code: 0xC0024104 Source: {90F9173A-94BA-4243-8B97-7FF1E0696C80}
Description: The Execute method on the task returned error code 0x80131904 (Login failed for user 'USER.NAME'.). The Execute method must succeed, and indicate the result using an "out" parameter. End Error
Warning: 2018-05-30 11:13:51.58 Code: 0x80019002 Source: OnPostExecute
Description: SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED. The Execution method succeeded, but the number of errors raised (2) 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
DTExec: The package execution returned DTSER_FAILURE (1). Started: 11:13:51 AM Finished: 11:13:51 AM Elapsed: 0.436 seconds. The package execution failed. The step failed.
May 30, 2018 at 10:35 am
bruce.dimon - Wednesday, May 30, 2018 9:21 AMAfter our DBA left, I changed the password on his account per policy. The maintenance plans he set up now fail. The history log of the subplan is below with the actual server and user names redacted. Where is the password stored for this user so that I can change it?Executed as user: DOMAIN\SERVER$. Microsoft (R) SQL Server Execute Package Utility Version 10.50.6560.0 for 64-bit Copyright (C) Microsoft Corporation 2010. All rights reserved.
Started: 11:13:51 AM Error: 2018-05-30 11:13:51.56 Code: 0xC00291EC Source: {43F60899-2946-44D5-B916-5948ECC83F78} Execute SQL Task
Description: Failed to acquire connection "Local server connection". Connection may not be configured correctly or you may not have the right permissions on this connection. End ErrorWarning: 2018-05-30 11:13:51.56 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 WarningError: 2018-05-30 11:13:51.58 Code: 0xC0024104 Source: Back Up Database Task
Description: The Execute method on the task returned error code 0x80131904 (Login failed for user 'USER.NAME'.). The Execute method must succeed, and indicate the result using an "out" parameter. End ErrorError: 2018-05-30 11:13:51.58 Code: 0xC0024104 Source: {90F9173A-94BA-4243-8B97-7FF1E0696C80}
Description: The Execute method on the task returned error code 0x80131904 (Login failed for user 'USER.NAME'.). The Execute method must succeed, and indicate the result using an "out" parameter. End ErrorWarning: 2018-05-30 11:13:51.58 Code: 0x80019002 Source: OnPostExecute
Description: SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED. The Execution method succeeded, but the number of errors raised (2) 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 WarningDTExec: The package execution returned DTSER_FAILURE (1). Started: 11:13:51 AM Finished: 11:13:51 AM Elapsed: 0.436 seconds. The package execution failed. The step failed.
Open the SSIS Maintenance packages and check the connections. You'll need to change the connections in the packages.
When you open a package, look at the top where it says Manage Connections...
Sue
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply