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

gpnt7bae  于 2023-08-02  发布在  其他
关注(0)|答案(2)|浏览(145)

I am facing the below error while executing an SSIS package on a remote server. I am using Windows authentication in my local environment and it's working fine without any issues. I maintain a package.config file for my variables to be deployed in other environments.

While running the built package in other remote servers with a connection string of that environment in package.config as per the 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 cause of this error.

yqhsw0fo

yqhsw0fo1#

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.

imzjd6km

imzjd6km2#

The issue was resolved for me after adding the account in the users list of the database.

相关问题