Monday 27 June 2016

Login failed for user “NT AUTHORITY\ANONYMOUS LOGON" BCS SharePoint 2010 and 2013

If you are getting below error when trying to retrieve data from External source using BCS

“Login failed for user “NT AUTHORITY\ANONYMOUS LOGON” while browsing to external list.”

RevertToSelf or BDC identity authentication is not enabled by default on a BCS Service application on a SharePoint farm, therefore this option won’t appear in the SPD by default. Run the following Power Shell (PS) script to activate it. (make sure you replace the name of the BCS Service Application with the correct one)
 


$bcsServiceApp = Get-SPServiceApplication | where {$_ -match "Business Data Connectivity Service"}

$bcsServiceApp.RevertToSelfAllowed = $true;

$bcsServiceApp.Update();

No comments:

Post a Comment