Allow BDC connect to SQL Server

When setting the Authentication mode of the External system properties in the Connection to BDC Identity, the following command shell below needs to be executed in the App Server.




$bdc = Get-SPServiceApplication where {$_ -match "BDC Service App"};

$bdc.RevertToSelfAllowed = $true;

$bdc.Update();



NOTE: Make sure that the application pool identity running on the SharePoint web server has the right privileges in the SQL Server data source.