Access denied by Business Data Connectivity
While creating an external content type in SharePoint Designer 2013 the following error was displayed when adding a connection to an SQL server using an impersonated custom identity: Access denied by Business Data Connectivity This occurred because the user does…
SharePoint 2013 – Configure the Secure Store and create a Target Application
I am configuring a Secure Store and creating a Target Application to store credentials for an external SQL database using SQL authentication. This is done in a few simple steps using Central Administration: Register a managed account to run the…