Login failed when using SQL Server Authenication in SSIS package RRS feed

  • 問題

  • 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 ?

    2009年3月17日 上午 08:20