cancel
Showing results for 
Search instead for 
Did you mean: 

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

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
Version history
Revision #:
1 of 1
Last update:
‎11-19-2018 01:08 PM
Updated by: