I am not sure what happened to my OLEDB connection and I am getting the below error when executing the SSIS package from SQL Server Agent Job. However, It works fine when I execute in the Visual Studio or in SSDT.
It is just saying 'Login failed' and not even saying 'Login failed for any particular user'.
Using : SQL Server 2012 R2
Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft SQL Server Native Client 11.0" Hresult: 0x80004005 Description: "Login failed. The login is from an untrusted domain and cannot be used with Windows authentication."
How can I debug this?
User contributions licensed under CC BY-SA 3.0