Not exactly suddenly, but right after I reinstalled SQL 2008 or right after I changed my password (I think this is probably the problem) my SSIS packages on my local server will not run. I changed my password back and they still wont run. Here is the error, any help would be great.
Edit: This is run on my local server. If anyone can think of a work around that would work great too.
06/03/2011 15:22:58,Test,Error,3,<USER-AKA ME>,Test,Amb,,Executed as user: NT AUTHORITY\NETWORK SERVICE. Microsoft (R) SQL Server Execute Package Utility Version 10.0.1600.22 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 3:22:59 PM Error: 2011-06-03 15:22:59.20 Code: 0xC0016016 Source: Description: Failed to decrypt protected XML node "DTSassword" with error 0x8009000B "Key not valid for use in specified state.". You may not be authorized to access this information. This error occurs when there is a cryptographic error. Verify that the correct key is available. End Error Error: 2011-06-03 15:22:59.25 Code: 0xC0202009 Source: AmbAlert Connection manager "192.168.30.205.EPO_Source.<ME>" Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E4D. An OLE DB record is available. Source: "Microsoft SQL Server Native Client 10.0" Hresult: 0x80040E4D Description: "Login failed for user '<ME>'.". End Error Error: 2011-06-03 15:22:59.25 Code: 0xC00291EC Source: Execute SQL Task Execute SQL Task Description: Failed to acquire connection "192.168.30.205.EPO_Source.<ME>". Connection may not be configured correctly or you may not have the right permissions on this connection. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 3:22:59 PM Finished: 3:22:59 PM Elapsed: 0.218 seconds. The package execution failed. The step failed.,00:00:01,0,0,,,,0
Edit: This is run on my local server. If anyone can think of a work around that would work great too.
06/03/2011 15:22:58,Test,Error,3,<USER-AKA ME>,Test,Amb,,Executed as user: NT AUTHORITY\NETWORK SERVICE. Microsoft (R) SQL Server Execute Package Utility Version 10.0.1600.22 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 3:22:59 PM Error: 2011-06-03 15:22:59.20 Code: 0xC0016016 Source: Description: Failed to decrypt protected XML node "DTSassword" with error 0x8009000B "Key not valid for use in specified state.". You may not be authorized to access this information. This error occurs when there is a cryptographic error. Verify that the correct key is available. End Error Error: 2011-06-03 15:22:59.25 Code: 0xC0202009 Source: AmbAlert Connection manager "192.168.30.205.EPO_Source.<ME>" Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E4D. An OLE DB record is available. Source: "Microsoft SQL Server Native Client 10.0" Hresult: 0x80040E4D Description: "Login failed for user '<ME>'.". End Error Error: 2011-06-03 15:22:59.25 Code: 0xC00291EC Source: Execute SQL Task Execute SQL Task Description: Failed to acquire connection "192.168.30.205.EPO_Source.<ME>". Connection may not be configured correctly or you may not have the right permissions on this connection. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 3:22:59 PM Finished: 3:22:59 PM Elapsed: 0.218 seconds. The package execution failed. The step failed.,00:00:01,0,0,,,,0
Last edited: