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.
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.
imzjd6km2#
The issue was resolved for me after adding the account in the users list of the database.