Cannot logon with credentials obtained from Secure Store Provider through SharePoint

Author by Hozafa Motiwala

 
1)   Make sure that the credentials that are set in the secure store have at least db_reader access to the database.
 
2)   Ensure the user making the request is a part of members group for the target application.
 
3)   Check the ULS logs for any signs of the issue.
 
4)   Create a SQL Account with SQL authentication and connect with impersonated custom identity.
Author

Hozafa Motiwala

Technical Architect