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

gpnt7bae 于 2023-08-02 发布在其他

关注(0)|答案(2)|浏览(144)

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.

sql-server

来源：https://stackoverflow.com/questions/48237922/ssis-error-code-dts-e-oledberror-an-ole-db-error-has-occurred-error-code-0x80

2条答案

按热度按时间

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.

赞(0）回复(0）举报 2023-08-02

imzjd6km2#

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

赞(0）回复(0）举报 2023-08-02