SP 2010: BCS problem with AuthenticationMode and RevertToSelf

Author: Tobias Zimmergren
http://www.zimmergren.net | http://www.tozit.com | @zimmergren

Introduction

I bumped into an issue the other week where I was creating a new BCS External Content Type and was hoping to hook up some new connections on a couple of demo farms I’ve created.

While most of these things were working like a charm, I bumped into an odd error message that basically told me that the elevation of privileges isn’t enabled on my BCS Service Application.

Problem, a short story told even shorter

You might receive an error message like this when trying to hook up a new External Data Source depending on your configuration:

The metadata object that has Name ‘yourName‘ has a Property with name ‘AuthenticationMode‘ and value ‘RevertToSelf‘. This value indicates that the runtime should revert to the identity of the application pool, but reverting to the application pool must be explicitly enabled for the service application by a farm administrator.

Solution

While digging around for a couple of minutes I couldn’t really find a suitable UI option for changing this behavior, so I dug into the power of PowerShell instead – which probably saved me quite some troubleshooting.

First you need to check the name of your Business Data Connectivity Service Application – a quick way is to check the UI, or you could use a PowerShell Cmdlet or use the API. I’m just using the UI for easy access:

image

Next, launch a new SharePoint 2010 Management Shell console and type in the following lines of code. Note that the name of the Service App below, is a copy of the name you took above:

$bcsServiceApp = Get-SPServiceApplication | where {$_ -match "Business Data Connectivity Service"}
$bcsServiceApp.RevertToSelfAllowed = $true;
$bcsServiceApp.Update();

This should now execute nicely (if you’ve got the appropriate permissions) and you should be able to see the RevertToSelfAllowed property be changed to true:

image

If you now would try to hook up your connections again, you should hopefully not see this message again.

Quick fix, done. Enjoy.

Follow me

Tobias Zimmergren

Founder / Consultant / Advisor at TOZIT AB
Tobias Zimmergren delivers high-quality articles about business and technology around the Microsoft scene.

Tobias focuses on advisory and consultancy for the Office 365 and SharePoint offerings from Microsoft.
Follow me
  • Pingback: Authentication mode | Olpera()

  • Igirigisamesa

    thanks for the lead but i still have an error like property RevertToAllowed cannot be found for the object. How is this fixed?

    • http://www.zimmergren.net/ Tobias Zimmergren

      You’ll have to elaborate on that.

  • ef1212

    Hi there-I attempted this fix but PowerShell responded by telling me “A potitional parameter cannot be found that accepts argume $null’/ At line:1 char:50, then a bunch of stuff about how it’s an invalid argument, then “You cannot call a method on a null-valued expression”

    • http://www.zimmergren.net/ Tobias Zimmergren

      Hi,
      Do you mind sharing the details of your commands?

  • Alan Wooley

    Tobias – Another GREAT solution! Thanks for solving the problem I was having.
    Alan Wooley

    • http://www.zimmergren.net/ Tobias Zimmergren

      Thanks Alan, much appreciated.

  • herr_herry

    Thanks, solved my problem too!

  • Pingback: SP 2010: BCS AuthenticationMode and RevertToSelf | The BI Guy: SharePoint Everything 101()

  • Pingback: Error changing BCS Authentication mode Revert to Self in SharePoint 2010 | Ram's Blog()