We recently in-place upgraded our sharepoint 2007 to sharepoint 2010.

We were using Windows authentication in the 2007 environment and wish to continue doing so in the 2010 environment.

The authentication provider for all web applications (portal | central admin | shared services) is Windows (NTLM). [EDIT: To clarify, this is in classic mode for all web applications].

If we load the people picker to assign permissions in our portal web application, it displays the classic mode view and works just fine.

If we load the people picker to assign permissions in our central administration, it displays the classic mode view and works just fine.

If we load the people picker to assign permissions to a Secure Store Service Targe Application, we receive an error "An error has occurred in the claim providers configured from this site collection".

I am confused. We are not using claims based authentication?

When the people picker loads, we see the Claims Based view rather than the Classic mode view (See http://technet.microsoft.com/en-us/library/gg602068.aspx for differentiation).

Any thoughts on why the People Picker would be trying to use Claims Based Authentication only when setting permissions for a secure store target application?

[EDIT: Further info] This is in the error log:

02/10/2012 14:52:12.43 w3wp.exe (0x1304) 0x0E18
SharePoint Foundation Claims Authentication 8307 Critical
An exception occurred in All Users claim provider when calling SPClaimProvider.FillHierarchy():
The connection name 'LocalSqlServer' was not found in the applications configuration or the connection string is empty.
(C:\Windows\Microsoft.NET\Framework64\v2.0.50727\Config\machine.config line 148).

NB: I am not looking for instructions on how to configure claims based authentication. I am trying to figure out why People Picker is using claims based authentication and how to stop it!

  • Has the machine.config file mentioned been changed? You mention that the Auth Provider is windows. But you are in "Claims-mode" or "Classic-mode"? Commented Feb 17, 2012 at 16:54
  • Hi Paul, no changes have been made manually to the machine.config. The authentication provider for all three web applications is classic. I have updated the question to clarify that. Commented Feb 22, 2012 at 0:52

3 Answers 3


Looks to me like there are some rogue configurations in your web.config. Did you ever set a custom membership/role provider manually or in IIS? Did you ever use FBA?

The error message you're getting looks like there is a custom membership provider set which uses a non-existing (or no longer existing) connectionstring for a local SQL server instance. So when you open up the people picker it tries to look up those members and fails.

I would check the web.config and verify the default providers and the people picker wildcards.

  • That was going to be my suggestion. If you had FBA configured at some point in time, it's possible that during the upgrade something got reverted there. Double check that the providers are setup correctly on the web applications. Also confirm the web.config for Central Administration and the STS services as they're all configured separately.
    – webdes03
    Commented Dec 16, 2012 at 13:28

There are many blogs suggesting for configuring proper Alternate Access Mappings in Central Admin to resolve this error. Did you try that out?

To know how AAM's are configured please visit the below links -



  • Hi Deepu. Yes, AAMs are configured for servername, FQDN and localhost. Commented Feb 13, 2012 at 1:07

probably you can try to remove PeoplePicker entry from web.config of your classic app

  • Ivan, thank you for responding, but your response does not help me at all.I don't want to remove PeoplePicker. I want to use PeoplePicker with Classic mode authenticaiton. Commented Sep 3, 2012 at 2:24
  • well, I didn't suggest to remove PeoplePicker. I was mentioned "PeoplePicker entry in web.config" :) Did you try that? And please also check web config for STS as well. Commented Sep 5, 2012 at 17:50
  • Fair point, sorry about that! I tried and it didn't help... Commented Oct 16, 2012 at 8:34

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.