Error “Login failed for user ‘NT AUTHORITY\ANONYMOUS LOGON” how to resolve in SharePoint 2010 BCS

Here are the steps to resolve BCS (SharePoint 2010) Error “Login failed for user ‘NT AUTHORITY\ANONYMOUS LOGON”:

Open Powershell (Run as Administrator) and type the following lines:

$bdc = Get-SPServiceApplication | where {$_ -match “Business Data Connectivity Service”}

$bdc.RevertToSelfAllowed = $true

$bdc.Update();

Once above is done, Open the External Content Type in SharePoint Designer 2010 and Click on Edit Connection Properties.

Once the Edit Connection Properties dialog opens, ensure that you have selected the “BDC Identity” value for the Authentication Mode property.
Go Back to the External Content Type read screen in your SharePoint site and hold your Ctrl key and click the refresh button on your browser.
The error “Login failed for user ‘NT AUTHORITY\ANONYMOUS LOGON” should now get resolved and you should see results displayed from yor Line of Business.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s


%d bloggers like this: