I have created external list from external content type, external content created from Azure SQL Database, but when i open the list it gives me following error.

Cannot connect to the LobSystem (External System). Reason: 'Cannot open database "Database" requested by the login. The login failed. Login failed for user 'User'.'

1 Answer 1


This problem might occur because of the connections authentication mode is not assigned to BDC Identity.

enter image description here

See the solution at Login failed for user ‘NT AUTHORITY\ANONYMOUS LOGON’ in SharePoint Business Connectivity Service

Check also Access Denied by Business Data Connectivity in SharePoint

  • When i use "BDC Identity" it gives me error "The metadata object that has Name <Name> has a Property with name ‘AuthenticationMode‘ and value ‘RevertToSelf‘. This value indicates that the runtime should revert to the identity of the application pool, but reverting to the application pool is not permitted for patitioned application service". Aug 31, 2016 at 8:25

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.