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 |
|
arkiboys
Master Smack Fu Yak Hacker
1433 Posts |
 Posted - 2012-01-10 : 08:34:20
|
| The error message below shows, there is a failure on connection to the connection manager.I have checked and the user SSISLoader with the correct password can connect to the query analyser.Do you know if certain permissions should be given to this sql user?ThanksMicrosoft (R) SQL Server Execute Package UtilityVersion 10.50.1600.1 for 32-bitCopyright (C) Microsoft Corporation 2010. All rights reserved.NULLStarted: 13:24:51Error: 2012-01-10 13:24:51.35 Code: 0xC0016016 Source: Description: Failed to decrypt protected XML node "DTS:Password" 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 ErrorError: 2012-01-10 13:24:51.80 Code: 0xC0202009 Source: FXRates Connection manager "DBName" 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 'SSISLoader'.".End ErrorProgress: 2012-01-10 13:24:51.90 Source: Send Mail Task The SendMail task is initiated.: 0% completeEnd ProgressProgress: 2012-01-10 13:24:52.90 Source: Send Mail Task The SendMail task is completed.: 100% completeEnd ProgressError: 2012-01-10 13:24:52.90 Code: 0xC00291EC Source: Purge Existing Imported Data Execute SQL Task Description: Failed to acquire connection "DBName". Connection may not be configured correctly or you may not have the right permissions on this connection.End Error |
|
|
|
|
|
failed to connect to connectionmanager