SharePoint Pals
 | Sign In
Steps to Configure Excel Services With Secure Store Target Application and SQL Database Service Account In SharePoint 2013
by Ahamed Fazil Buhari 27 Dec 2016
Author
SharePoint Developer
Visits   
Today  :   12     Total  :    497

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

blog comments powered by Disqus

SharePoint Pals

Pals
SharePoint Pals, a community portal for SharePoint developers, Administrators and End Users. Let's join hands and share the point together.
Read this on mobile

Training

Angular Js Training In Chennai
Advanced Angular Js training with real world developer scenarios
Angular Js, Web Api and Ionic for .Net Developers
All in one client side application development for .Net developers
Angular Js For SharePoint Developers
Get ready for the future. Its no more just C#

Get Connected

SharePoint Resources

SharePoint 2013 and 2010 Web Parts
Free Web Parts with Source Code for SharePoint Community




SharePoint 2013 Books and Tutorials
Collection of free SharePoint 2013 books and tutorials (eBooks, pdfs)

Supported By

Contribute your article and be eligible for a one month Free Subscription for Plural Sight. The Author of the most popular New Article (published in the previous month) will be awarded with a Free One month Plural Sight Subscription. Article can be sent to articles@sharepointpals.com in a word document.

Related Resources

Recent Tweets

Twitter January 15, 00:25
How To Enable Target Value And Actual Value In #D3 Gauge Chart https://t.co/VxSi4QnNrC

Twitter January 15, 00:24
How To Open #SharePoint List Hyperlink Column In Modal #Popup Window https://t.co/EQ7HkoZDkX

Twitter January 15, 00:24
Quick Introduction To #Asp.NetCore And It’s Features https://t.co/zAXObHCFpH

Twitter January 15, 00:22
How To Configure #PerformancePoint Services To Use Secure Store In #SharePoint 2013 https://t.co/LEwnUoI7EY

Twitter January 15, 00:21
How To Block Or Disable #Office365 Services https://t.co/Yvp2VPFIRP

Follow us @SharePointPals
Note: For Customization and Configuration, CheckOutRecent Tweets Documentation