Connecting to Microsoft SQL Server database

Complete the following steps to connect to database on a server running Microsoft® SQL Server®:

1. Under Data Source, click Microsoft SQL Server, and then in the server name text box, type the name of the SQL Server.
2. From the authentication mode drop down list, select either User Name and Password or Windows Authentication.
3. When User Name and Password is selected, type the SQL user name and password in the text boxes provided.
4. Click the blue arrow to the right of the database name drop down list to populate the list with all the databases the authentication credentials has access to.
5. In the database name drop down list, select the database which you want to use as a basis for your external content types.
6. Select the use secure store check box, if you want to use a SharePoint Secure Store Service.
   
7. Click the blue arrow to move to the next step – build one or more external content types
   

*The following scenarios in the Walkthroughs section connect to a Microsoft SQL Server.
  * Creating an External Item Picker for Foreign Keys.
  * Mapping Office Item Type properties to External Content Types fields.
  * Using SQL Server stored procedures to create BCD Specific Finder and IdEnumerator operations.
  * Using SharePoint 2013 Secure Store Service with BCS and Microsoft SQL Server.

Connecting to Dynamics CRM Online →