Steps to Configure Excel Services With Secure Store Target Application and SQL Database Service Account In SharePoint 2013


Ahamed Fazil Buhari
SharePoint Developer
Published On :   27 Dec 2016
Visit Count
Today :  2    Total :   1188
Plan, Migrate, Secure, Report
SharePoint & Office 365 Tool. Simple & Easy to Use. 15-Day Trial!

SharePoint Office 365 Tool
Simple & Powerful Tool for Migration, Security & Reporting. Free Trial


This is the continuation of my previous article “How to Create a New Target Application in Secure Store Service - SharePoint 2013”. Alright, now in this article we’re going to go ahead and take that Target Application which we created earlier and assign it to Excel Services. Below you can find step by step approach to achieve this.

Step 1: Go to Central Administration -> Manage service application.

image

Step 2: Click on Excel Services in ServiceApplications.aspx page.

image

Step 3: In Manage Excel Services Application page, go to Global Settings.

image

Step 4: Under Global Settings you can find lots of things in that. Now scroll down and go to the bottom of the page to the Unattended Service Account and we can create a new unattended service account or we can use the existing unattended service account.

Here, we’re going to use existing unattended service account option and provide the Target Application ID, (To know how to create the Target Application ID, then refer my previous article “How to Create a New Target Application in Secure Store Service - SharePoint 2013”) and click on OK.

image

Now Excel Services has that Target Application to use. Anytime the Excel Services tries to reach out to our SQL, then it will use those credentials provided in Target Application.

Still we need to go ahead and tell the SQL to allow that account to have various access like read/write and whatever we want in data.

Add Service Account Login to SQL Database

Step 1: Open SQL Server Management Studio.

image

Step 2: Go to Security -> Logins and right click on it and choose New Login.

image

Step 3: Here we’re going to use Windows authentication and provide the account name which we need to give access.

image

Step 4: Click on User Mapping in left navigation and map it to the database which want to access. And also provide the access to the roles like db_datareader, public, db_securityadmin, db_owner and click on OK.

image

That is all we need to do for our Target Application to have access to our database.

Happy Coding

Ahamed

SharePoint Usage Reports
Usage reports, collaboration and audit for SharePoint.
Categories

KWizCom Forms App