Export (0) Print
Expand All

Configure the Secure Store Service for a Business Connectivity Services on-premises solution in SharePoint 2013

SharePoint 2013

Published: October 16, 2012

Summary: Link to a configuration of the Secure Store Services for a Business Connectivity Services (BCS) on-premises solution in SharePoint 2013.

Applies to:  SharePoint Server 2013 | SharePoint Foundation 2013 

The Secure Store Service stores the credentials that Microsoft Business Connectivity Services uses to access the AdventureWorks external data source and performs credential mapping between your users accounts and the credentials used to access the external data source.

Important Important:

This is Step 6 in the Business Connectivity Services On-Premises scenario deployment procedures.

Parameters for configuring the Secure Store Service for a Microsoft Business Connectivity Services on-premises configuration

In this procedure you perform all the steps in Configure the Secure Store Services in SharePoint 2013 Preview article. You must perform the steps in the Configure the Secure Store Services in SharePoint 2013 article with these parameters from start to finish.

Configure Secure Store Service for on-premises Business Connectivity Services

  1. Perform all the steps in Configure the Secure Store Services in SharePoint 2013 Preview with the following parameters.

  2. Open the SharePoint Central Administration website for the server farm that your Secure Store Service is in with an account that has Farm Administrator permissions.

  3. In the Configure the Secure Store Services in SharePoint 2013 Preview article, perform all procedures in the Configure Secure Store section with these parameters

    1. For the Register Managed Account, User name type in the name of the service account that you created in the Prerequisites for deploying a Business Connectivity Services on-premises solution in SharePoint 2013 procedure.

    2. Do not select the Enable automatic password change box.

  4. Perform the “To start the Secure Store Service” procedure

  5. Perform the “To create a Secure Store Service application" procedures using these parameters

    1. In the Service Application Name box enter the name you want the service to appear as on the Manage Service Applications page.

    2. In the Database area, leave the prepopulated values for Database Server, Database Name, and Database authentication, which is Windows authentication (recommended) unless you have specific design needs to change them.

    3. If you have SQL Server database mirroring configured and you want to include the Secure Store Service in mirroring, provide the name of the failover database server in the Failover Database Server box.

    4. For the Configurable dropdown, select the account that you registered as a managed account earlier in this procedure.

  6. Perform the steps in the Work with encryption keys section with these parameters:

    1. Don’t perform the procedures in the “Refresh the encryption key” sub-section

  7. Read the Store credentials in Secure Store section and perform the Create a target application procedure using these parameters.

    1. In the Target Application ID box type in a string for the target application; this is not the display name. For example type in AWTargetAppID.

    2. In the Display Name box, enter the display name you want, for example Adventure Works Target Application ID.

    3. In the Target Application Type dropdown, select Group (which indicates the mapping of many credentials to one credential). In this case, the Target Application Page URL is not needed and automatically selects to None.

    4. On the Create New Secure Store Target Application page, under Field Name, change Windows User Name to SQL User Name, and Windows Password to SQL Password.

    5. Under Field Type change Windows User Name to User Name and change Windows Password to Password.

    6. In the Target Application Administrators add the accounts that you want to be administrators of the Target Application. Note that the Farm Administrator has access by default.

    7. In the Members box, add the names of the users whom you want to allow access to the external data source. For this example use the AdventureWorksBCSUsers security group you created in Prerequisites for deploying a Business Connectivity Services on-premises solution in SharePoint 2013.

  8. Perform the steps in the Set credentials for a target application procedure using these parameters:

    1. In the SQL User Name box, type AdventureWorksUser which is the name SQL Server account you created in Create database logins for a Business Connectivity Services on-premises solution in SharePoint 2013.

    2. In the SQL Password, and Confirm SQL Password boxes type the password for that account, which is actually the password for the SharePointGroupAccount account that you created in Create database logins for a Business Connectivity Services on-premises solution in SharePoint 2013.

Important Important:

Link to Step 7Create an external content type for a Business Connectivity Services on-premises solution in SharePoint 2013 of the Business Connectivity Services On-Premises scenario deployment procedures.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft