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.
    Click blue arrow to move to next step
  7. Click the blue arrow Next to move to the next step – build one or more external content types

Connecting to Dynamics CRM Online →


Was this helpful?

Yes No
You indicated this topic was not helpful to you ...
Could you please leave a comment telling us why? Thank you!
Thanks for your feedback.

Post your comment on this topic.

Please do not use this for support questions.
For customer support, please contact us here.

Post Comment