Company News

The Given Key Was Not Present in the Dictionary – SharePoint 2010 Error

September 5, 2010

Ok, I’ve run into this enough times now that I figure folks may not stumble across the Technet article that has already discussed this ( I’ve seen this in three scenarios so far:


Number One: When running the SharePoint Configuration Wizard, if the account you have defined for your SQL Server connection is different than the account you are installing (and it should be, but it doesn’t fail with the install account as it has local server admin rights), you may get the following:


Figure 1 : During the SharePoint Configuration Wizard, this may occur if the account you specified for the SQL Connection is the issue


Number Two: When trying to run the configuration wizard after a fresh SharePoint install (I know, we don’t want to run the wizard in production, but in testing, etc. this will come up), you may see it as well:


Figure 2 : When running this configuration wizard after SharePoint is installed, in Central Administration (why?)


Figure 3 : You may find yourself with it occurring here too


Figure 4 : As you can see from the correlation ID, it is attempting to lookup that account


Number Three: When attempting to register a new Managed Account, you may come across it as well:


Ok, so what is the fix?

It’s pretty simple actually. The account you are attempting to work with, cannot be queried by the system. Although I’m sure there is a more granular permission we can set that giving read to all authenticated users on the object, this one seems to do the trick every time:


  1. Open Active Directory Users and Computers
  2. Select “Advanced Features” from the View Menu
  3. Open the properties of the desired account
  4. Select the “Security” tab
  5. Find Authenticated Users and give them READ permission on the user object
  6. Click OK to close out and try again. You may want to consider doing this for any managed accounts you define in Central Administration


Figure 5 : Set read permissions for Authenticated Users on the account object and Voila!


Again, a growing discussion on the topic is here:


One Response

  1. […] for SharePoint and Power View. A step by step description about how you can do that is available here (read the “Ok, so what is the fix?”). A more complete explanation is included in this post by […]

Leave a Reply

Sean Wallbridge

Sean Wallbridge-square-150x150

Beer Me!

Subscribe via Email


Powered by...

itgroove Corporate Profile
Connect With Us