In SharePoint Server,When I tried to browse an external list, but unfortunately I got the following error :
Login failed for user ‘NT AUTHORITY\ANONYMOUS LOGON'
This problem might occur because of the connections authentication mode is not assigned to BDC Identity.
- Open SharePoint Designer > Go to External Content Types > Click Edit Connection Properties.
- Below Connection properties > Select Default > Below Secure Store Application ID > Select BDC Identity.
- Below Connection properties > Select Client > Below Secure Store Application ID > Select BDC Identity.
- Go back to browse an external list that should now been worked properly.