Using SQL Authentication and Secure Store Service to read data from SQL Server SharePoint 2010 External Content.
I have seen many articles on creating external content types to read data from SQL server. Most of these articles are explain about reading data from the database using Windows authentication. Windows authentication to read data from a database won't work in many scenarios. We have to use SQL authentication to read or manipulate data from SQL. Here we have to use secure Store Service to use SQL authentication.Here I am showing five things
SharePoint Online And Office 365 Administration