Export (0) Print
Expand All

Create database logins for a Business Connectivity Services on-premises solution in SharePoint 2013

SharePoint 2013
 

Applies to: SharePoint Server 2013, SharePoint Foundation 2013

Topic Last Modified: 2013-12-18

Summary: How to prepare the SQL Server logins for Business Connectivity Services (BCS) on-premises scenario deployment in SharePoint 2013.

Microsoft Business Connectivity Services (BCS) requires an account that it can use to access the external data source. The account must have the necessary permissions on the external data source to perform all the operations that your BCS solution might require. For ease of configuration and ongoing management, you can map a group of SharePoint products users to a single shared account on the external data source.

In this procedure, you create a SQL Server login and then assign that login to a user account on the AdventureWorks sample database. You will use Secure Store Service services to map a group of SharePoint 2013 users to the single shared account in a later procedure.


ImportantImportant:
This is Step 2 in the Business Connectivity Services On-Premises scenario deployment procedures.


Create a SQL Server login
  1. Start SQL Server Management Studio.

  2. In the Object Explorer, expand the <database server name>, expand Security, and then expand Logins.

  3. Right-click Logins, and then click New Login

  4. In the Login Name box, enter SharePointGroupAccount.

  5. Select SQL Server authentication, and then enter and confirm a password.

  6. In the Default database box, select AdventureWorks2008R2, and then click OK.

Create a SQL Server user on the AdventureWorks database
  1. In the Object Explorer, expand Databases, expand AdventureWorks2008R2, expand Security, and then expand Users.

  2. Right-click Users, and then click New User.

  3. Under the Login Name, with the User name box pre-selected, in the first box, enter AdventureWorksUser

  4. In the second box, click Browse, in the Select Login dialog box, click Browse, select the SQL Server account, SharePointGroupAccount, and then click OK twice.

  5. Under Database Role membership, select db_owner.

  6. Click OK.

  7. Close SQL Server Management Studio.


ImportantImportant:
Link to Step 3 Start the Business Data Connectivity service 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