External Content Types using SQL Server Authentication Business Connectivity Services (BCS) is new in SharePoint 2010, which is used to be called Business Data Catalog (BDC) in SharePoint 2007. You can create External Content Type (ECT) with BCS that let you define a connection to a web service or database server that is external to SharePoint. How to create External Content Type Based on a SQL Server 2008 Table: I am going to show steps for a scenario where we will use single SQL account to impersonate when we access the external data from SharePoint. Things to note before to implement scenario:
- Which SQL Server account needs to use for impersonation?
- Which group of users need to give access to the data? In my scenario I am going to use domain users group which is everyone. I will restrict use access at site level, if anybody will have access to SharePoint site they will have automatically access to external SharePoint list, which will be connected to SQL Server table (more…)