Click here to Skip to main content
65,938 articles
CodeProject is changing. Read more.
Articles / productivity / SharePoint

Secure Store Service in SharePoint 2013

0.00/5 (No votes)
16 Sep 2014CPOL2 min read 25.7K  
Secure Store Service in SharePoint 2013

Introduction

In this article, we will learn how to configure the Secure Store Service on SharePoint Server 2013.

About the Secure Store Service

This service is running on an application server and providing the authorization. The Secure Store Service provides a database that is used to store credentials. The Secure Store Service provides support for storing multiple sets of credentials for multiple back-end systems.

The main usage of this service includes Excel Services, Visio Services, PerformancePoint, Business Connectivity Services (BCS), Power Pivot, etc.

For example, when we are connecting Excel with external data sources, it needs to pass the user credentials like user name and password. These type of scenarios we can solve with configure an unattended service account for the external data access.

Target Applications

A target application is a collection of information that maps a user or users to a set of encrypted credentials stored in the Secure Store database.

Configuration Steps

Open the central Admin=>System Setting =>Manage Services on Server

Image 1

Start the Secure Store Service.

Image 2

Then open the security =>General Security =>Configure Managed Account.

Image 3

Create a separate user account in active directory for each service based on your requirement.

Please enter the user credentials here.

Image 4

And Open the Manage Service Application.

Image 5

Click on NEW button and select Secure Store Services.

Image 6

Enter the Service Application Name, DB Server Name, DB Name and Authentication type here.

Enter.

Image 7

The new service is created as ‘Secure Store Service’.

Image 8

Click on the Secure Store Service and Generate New Key.

Image 9

Enter the Pass Phrase here.

Image 10

Then we need to create a new Manage Target Application. Click on New button.

Image 11

Enter the Target Application ID Details here and click on Next Button.

Image 12

Then click on Next.

Image 13

Enter the Target Application Admin Details here and click OK.

Image 14

Conclusion

In this article, we learned how to configure the Secure Store Service in SharePoint 2013.

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)