Hi all,
I have developed a SSIS package. When I used integrated security in the connection managers (I have two connections to different SQLServer, one is 2008 and one is 2000), the execution completed successfully.
When I changed one of the connections (which connect to a SQLServer 2000) to use SQL Server Authenication, it failed with the following error:
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 '_BI-DIR'.".
Error: 0xC020801C at Collect Coal Consumption from PHD, Extract coal consumption from PM [1]: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER.
The AcquireConnection method call to the connection manager "gichk_pro_pm" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed.
I am quite sure the user name and password is correct as I used the "Test Connection" button to verify it. I have also checked the "Save my password" option.
I have also verified the user login / password with ISQL. Sufficient rights have granted on the target database.
When I changed back to use integrated security, it worked seamlessly.
Did I still miss something ?
