Recently, we were working on SSIS for ETL(Extract, Transform and Load) to get the data from AX and push to the staging tables. We were using linked server for AX and we were using Windows Authentication for connecting to it.
While running the package from SSDT, it got executed successfully. So, we deployed the packages to SQL Server.
After deployment when we executed the package we got the below error:
“Login failed for user NT AUTHORITY\ANONYMOUS LOGON” for linked server that we were using.
To fix this issue, we used SQL server credential to connect to AX using Linked server instead of Windows Authentication. Then we compiled the solution, deployed the packages to SQL Server and executed the package from SQL Server and it got executed successfully.
Hope it helps !!