0

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'.'

Improve this question

1 Answer 1

Reset to default
0

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

Improve this answer
1
  • 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".
    – Trimantra Software Solution
    Commented Aug 31, 2016 at 8:25

Your Answer

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

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