SSIS: Login failed for user “NT AUTHORITY\ANONYMOUS LOGON”

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 !!

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.