BCS Error – Login Failed for User

You will get the following error while first time configuring BCS.

Error

Message from External System: ‘Login failed for user ‘NT AUTHORITY\ANONYMOUS LOGON’.’.

image

Solution

Following would be the solution.

Open SharePoint Designer. Go to External Content Types > Open BCS item > Click Connection Properties button.
Choose the Authentication Mode as BDC Identity as shown below.

image

Save changes & Retry opening your BCS List.

Summary

In this post we have explored a common error while configuring BCS & steps to resolve it.

Leave a Reply

Your email address will not be published. Required fields are marked *