SharePoint 2010 features by versjon / SKU

Great page for all (?) the answers about SharePoint 2010 and which versions contains which features/capabilities:



SharePoint 2010 Excel Services - "The workbook cannot be opened."

Setting up a new SharePoint 2010 farm "by-the-book" introduces some extra tasks getting the service and pool accounts right. I was using a unique account for Excel Services and Performance Point services, but was getting the very generic error:

"The Workbook cannot be opened."

A quick Google search sent me to this article by Jeremy Jameson.

The conclusions here are that again there are powershell commands that will do the trick:

$w = Get-SPWebApplication

(per web application)


How to quickly find the Assembly Name when working with SharePoint 2010 in VS 2010?

Finally I found a tool that integrates with Visual Studio 2010 that lets me extract the the complete Assembly Name (e.g "FrodesDelegateControl, Version=, Culture=neutral, PublicKeyToken=73ed919f5d6aada1") from my current Visual Studio 2010 project.

How to: Create a Tool to Get the Full Name of an Assembly

It's so simple - why didn't I think of it myself? Read the article, create the application, install it and of you go.

The area of spelling mistakes, wrong PublicKeyToken, etc., is finally over!

Enterprise 2.0, Web 2.0 and Social Networks - what does it take to succeed when trying to make changes?

How to succeed when trying to change a organisation or company seems to be closely linked to the leader's networking strengths. See: Survey: Informal Networks Linked to Success of Change Initiatives, and:

93% of completely successful change initiatives were led by leaders with very strong or strong personal networks. Not one change initiatives described as less successful was led by leader(s) with strong or very strong personal networks.

Maybe not a big surprise (good and great leaders have always been good with people), but in a world where social networks - both internal and external - have become a driving force in many aspects and especially in how we are doing our work and collaborate, social "weak" leaders and managment are "doomed" to fail.

But the same survey also found that formal networks still are very important :
However, survey respondents overwhelmingly reported that those formally involved in change initiatives were more helpful than those outside the formal change teams.

One of the conlusions made by those analysing the findings is:
Change initiatives are dependent on leaders for moving the project forward, making decisions, and giving personal advice. The catch is to make sure that those leaders are accessible to others on the change team and available to help. Implied in survey results is that leaders are needed to play an active role on change initiatives, not simply sponsor projects from afar. HR can help by encouraging leaders to limit the number of change

Is this related to SharePoint 2010? I absolutely think so! Implementing SharePoint 2010, and maybe expecially its new social computing capabilities, will demand a (big?) change in how people in small and large enterprise collaborate. And as most of us don't really like changes, it will be challenging from top management to the people on the floor.

SharePoint 2010, PowerShell ISE, and Developer Dashboard

To get my developer mchines ready for developing, customization, configuration and administration I have to go through the steps to automatically load the sharepoint powershell commands when starting PowerShell ISE, and get the developer dashboard ready:

Load SharePoint 2010 commandoer everytime I start PowerShell ISE:

Enable the Developer Dashboard:

  • $contentservice = [Microsoft.SharePoint.Administration.SPWebService]::ContentService
  • $devdash =$contentservice.DeveloperDashboardSettings
  • $devdash.DisplayLevel =[Microsoft.SharePoint.Administration.SPDeveloperDashboardLevel]::OnDemand
  • $devdash.Update()


Cannot create new sites in SharePoint 2010

When I tried to create a new Enterprise Wiki site I got a general error message with a correlation ID. Checking the ULS i found the following error:

"Detected use of SPRequest for previously closed SPWeb object. Please close SPWeb objects when you are done with all objects obtained from them, but not before"

Not much help. But I found another artical by Todd Carter, who had debugged the issue, that activating the SharePoint Publishing Infrastruture would fix the issue. I had this feature already activated, but deactivating it and activating it fixed the issue in my case as well.


Configuring the User Profile Service in SharePoint 2010 - errors and issues

Possible issues and errors:

"This User Profile Application’s connection is currently not available. The Application Pool or User Profile Service may not have been started. Please contact your administrator"

  1. An iisreset is the first thing to do!

You are having problem getting the User Profile Syncronization started and can't get the Forefront Indentity Manager services to run.

"ERR: MMS(4828): libutils.cpp(10475): RegQueryValueEx of Server failed with 2
BAIL: MMS(4828): libutils.cpp(10477): 0x80070002 (The system cannot find the file specified"

  1. Make sure the farm account you entered when installing SharePoint has all the needed access/rights in AD: http://technet.microsoft.com/en-us/library/ee721049(office.14).aspx . The issues is also discussed here: http://social.technet.microsoft.com/Forums/en-US/ilm2/thread/db5bb837-1e95-4b50-9441-8bb37f4f0ee3/
  2. A manual fix to the problem can be found here: http://itgoran.com/index.php/2010/05/09/the-system-cannot-find-the-file-specified-the-server-encountered-an-unexpected-error-and-stopped-fim-2010-solved