Error "Access is denied to the Secure Store Service" using SQL Request Control

Document created by butlerj Support on Nov 19, 2018
Version 1Show Document
  • View in full screen mode
ISSUE
When using the SQL Request Control, the following error might occur:

Access is denied to the Secure Store Service.

Additionally, the control will not function, and access denied errors will be found in the ULS logs when attempting to access SQL data using the control.
ERROR CODE
RESOLUTION
Add the Web Application Pool account to the members for the Secure Store Target Application:
  1. Navigate to: SharePoint Central Administration > Application Management > Manage Service Applications > {Secure Store Name} > {Target Application ID}
  2. Click Next and navigate to the Edit Secure Store Target Application page.
  3. Add the Web Application Pool account in the Members section.
ADDITIONAL INFORMATION
RELATED LINKS

Attachments

    Outcomes