Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'

Login failed for user 'NT AUTHORITY\ANONYMOUS  LOGON'

When you create Business Data Connectivity Services with SQL Server using SharePoint Designer, above error will come because of , External System not getting proper identity to connect. To resolve the problems relating BCS authentication consider below steps

How to change BCS Authentication Mode.

1.       Change the Authentication mode to BCS Identity

2.       If you get error, please update the BCS  “RevertToSelfAllowed”  to true using below Powershell command.

To list down SPservices Ids and then copy Business connectivity id

          Get-SPServiceApplication;

To get Business connectivity service

$bcs = Get-SPServiceApplication  -ID  ”<<Id>>”

$bcs. RevertToSelfAllowed  = $true

$bcs.Update();

Note: after update  you might need  reset IIS

3.       Although you update BCS credential  , it might show error message on the page like below

In my scenario ,I  saw below errors log the  in Event Viewer

To resolve the problem,

1.       Verify your site App pool account have sufficient credential in DB

2.       In SQL server , “User Mapping” data base for App pool account

3.       Verify relevant user “Schemas “ and  “Data base Role Membership”