SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E4D

1
votes

Hi I am facing the below error while executing the ssis package in remote server.I am using windows authentication in my local and it's working fine without any issues.I am maintaining package.config file for my variables to be deployed in other environments.

While running the built package in other remote server with connection string of that environment in package.config as per server it's failing..

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 11.0" Hresult: 0x80040E4D Description: "Login failed for user 'abc\xyz'

I am unable to find the reason.

2
sql-serverssisoledbetl
Investigate the login failed part of the error message. - Jeroen Heier
Is that the windows authentication which is causing the issue? - Bijay Nandagiri
Are you trying to use a windows authentication of a machine on other machines??!! - Hadi
yes, but my login account has permission on all the other machines too where I want to deploy it.. - Bijay Nandagiri
@BijayNandagiri are you running this package from SQL agent Job or what? - Hadi

2 Answers

1
votes

If you are running the package from a SQL agent Job than you have to add a proxy account, you can follow one of these links for a step-by-step asnwer.

0
votes

The issue solved for me after adding the account in the users list of the database

Thanks