SharePoint 2010 certifcation run ended today,

and all 4 certifications for SharePoint 2010 passed. Then it's Christmas!


Just 1 to go! Just passed the PRO: Microsoft SharePoint 2010,Administrator (70-668) exam

The last one: "70-576: Designing and Developing Microsoft SharePoint 2010 Applications" will be taken later this month (I hope :-)).


Impossible to delete the Search Service Service Application from the Gui in SharePoint 2010

Ok, I had to get this issue as well: Corrupt Search Service application in my development environment. I was not able to delete it from Central Administration so I had to find the correct powershell comands. Clean up by runnning these two commands:
  1. Get-SPEnterpriseSearchServiceApplication -Identity "Search Service Application"
  2. Stsadm -o deleteconfigurationobject -id [Guid returned from previous command]


Access denied when trying to crawl sps3://mydomain

I've had a lot of Access Denied messages when configuring SharePoint 2007 and SharePoint 2010, and especially when trying to switch service accounts or accounts to be used when SharePoint crawls content.

This time I got an access denied when trying to crawl sps3://mydomain. Checked account, password, assigned rights (Site Collection, Web Application Policies, etc), but everyhing looked ok. Hmmm... using Google I found and read a post in the Enterprise Search forum on msdn and this blog article.

These steps fixed my issue:

  • Go to the Service Applications page
  • Select the User Profile Service Application (NOT the link)
  • Click on the administrators button
  • Add your crawl / indexing count
  • Give it the permission: Retrieve People Data for Search Crawlers
  • Click Ok

The perform a new Full Crawl of your content source(s), and hopefully no access denied messages any more,

SharePoint 2010 User Profiles Syncronization fails

In a SharePoint 2010 installation that I recently worked we got Failures in the log when trying to perform a User Profile Syncronication. The account, domain, etc where all correct. Having Googled a bit we thought that it might be a FIM related issue.

Opening the Syncroniztion Service Manager (C:\Program Files\Microsoft Office Servers\14.0\Synchronization Service\UIShell\miisclient.exe) we found the error: "The management agent failed on run profile "DS_FULLIMPORT" because of connectivity issues." Why??

We went through the checklists, guidelines and what we had done, and everyhing looked correct; correct user account, we've set the Grant Replicate Directory Changes permission on the cn=configuration manager, the FIM services where running correctly, etc.

But of course I had missed one step (there is always something :-( ): Granting Replicate Directory Changes permission on the domain.

So you must add Replicate Directory Changes permissions both on the domain AND the confiugration container!

It's all documentet on TechNet: Configure profile syncronization.


SharePoint 2010, REST API, JSON, Javascript , JQuery AND correct Date handling/serialization

Today I created a Javascript that displayed the calendar events from a SharePoint calendar. I used Javascript and SharePoint's REST API to inject the result in a cusom Spot web part that I've written. Combining the REST API and JQuery was straightforwad, but I ran into trouble when I was going to display the calendar event's start date.

It turns out that JQuery date serialization and WCF date serialization differs. Luckily (for me) I found the description of the issue and a solution written by Steve Commisso. Read it here.

Key elements in the JavaScript:

SharePoint 2010 Certifaction Run Started!

Then I've started my SharePoint 2010 certifaction run. I'm planning to complete all 4 by the end of the year.
  • 70-573 TS: Microsoft SharePoint 2010, Application Development. Sept. 2010. Passed!
  • 70-667 TS: Microsoft SharePoint 2010, Configuring. Okt 2010. Passed!
  • 70-668 PRO: SharePoint 2010, Administrator. Nov 2010. Passed!
  • 70-576 PRO: Designing and Developing Microsoft SharePoint 2010 Applications. Des 2010. Passed!


Using, embedding and deploying resources (gif, css, javascripts, etc) when writing SharePoint 2010 web parts

I came across an article by Maurice Prather, "Web Part Class Resources - a forgotten storage location", and I also failed to answer his question; What are Web Part resources? I've never thought about this way of deploying resources used by and in my web parts. I've more or less always used the "classical" way of deploying my images, css, js, etc to the /layouts/mydirectory. That may change in the future!

But here is also anohter option, and that is to deploy the resources as WebResource. I'm not 100 % sure that I can answer you when to use what method, but i gues WebResources should be used in non-webparts scenarios, and/or SharePoint solutions where the same resource is to be used by different sharepoint items (Web parts, Application Pages, etc).

On CodeProject you'll find a working example where both methods have been used: Site Map Web Part.


SharePoint Roadmap for Collaboration Masterclass with Michael Sampson

On October 6. 2010 Michael Sampson will visit Bergen, Norway, and hold his SharePoint Collaboration MasterClass. It is a one-day seminar open to everyone. It will be heldein our (EDB Consulting Group) office on Bryggen.

More information here (in Norwegian): http://www.edb.com/no/Konsern/Aktuelt/Eventkalender/SharePoint-Roadmap-for-Collaboration-Masterclass/


Are you going to use PowerPivot in your SharePoint 2010 farm?

Then make sure that you meet the following SQL Server 2008 R2 requirment that will have a great impact on your SQL Server license cost:

"You must have installation media for the Enterprise, Evaluation, Developer, or Data Center editions of SQL Server 2008 R2. "

That means that PowerPivot on top of SQL Server 2008 R2 Standard Edition is NOT possible.

Install PowerPivot in a new farm

Install PowerPivot on an existing farm

Other comments:
  • PowerPivot for SharePoint adds SQL Server 2008 R2 Enterprise files to your SharePoint application Server


Configuring the People Picker in a trusted domain scenario and Sharepoint Foundation 2010

If you get an Access Denied message when trying to run the stsadm commands such as setpassword and setproperty then open the command prompt windows as an Administrator, and try again.

Setting the correct search scope for the people picker:
  1. stsadm -o setapppassword -password xxxxxx
  2. stsadm -o setproperty -pn peoplepickser-searchadforests -pv "domain:first.com;domain:second.com,domain\user,password" -url http://sharepoint2010/

First.com domain trusts users from second.com. For the people picker to find users in the second.com domain a valid user in second.com domain has to be provided. Because we provide a user name and password we first have to set the password encryption key.

Error when deploying SharePoint 2010 web parts in an upgraded Visual Studio solution

I had a Visual Studio 2008 web part solution that I upgraded to a Visual Studio 2010 solution. It looked like everything was going to be ok, but I got the following error in the ULS when trying to add the web parts to a page:

09/09/2010 14:08:36.82 w3wp.exe (0x269C) 0x1998 SharePoint Foundation Web Parts tkqj High WebPartAdder_InvalidDwpUrl

Checking the solution again the web parts where added as modules and not web parts to the solution.

I ended up deleting the web parts (except the source code of course), adding new web part items, and adding the deleted code. Now it is working as it should

Web parts dissapears from a wiki page or a content field when added

I think there is a bug here. Several times I've experienced that my custom (and standard) web parts just dissapears when inserted in a wiki page or a content field on a publishing page. SharePoint thinks it is visible - append ?contents=1 to the Url - but no it is NOT there.

Create a regular web part page, add your web part and you should be up and running (again).


"The install in progress conflicts with a previously installed Microsoft Office 2010 Server product"

Did you get this message "The install in progress conflicts with a previously installed Microsoft Office 2010 Server product" after an uninstall (on e.g. your development server) then it's very likely that there are som Office Web Apps garbage in your registry.

You may start with this article: "Installing Sharepoint 2010 over a previous version", or (as I did) just open regedit, search for "Web Apps" and just delete every entry you can find. Easy as hell, but proobably not something you would do on a production server :-)


What web parts comes with which SharePoint (Foundation, Standard and Enterprise) version / SKU / License?

I'm happy to say that I didn't have to compile this list myself, but can safely redirect you to Ari Bakker's blog, and his nice page: SharePoint 2010 Web Parts by License Type.

Sumarized these are the important ones that comes for free (SharePoint Foundation):

  • ContentEditor.dwp
  • Image Viewer
  • Members
  • Page Viewer
  • Picture Library Slideshow
  • Simple Form
  • User Docs
  • User Tasks
  • Xml Viewer
  • Silverlight


Norwegian Language Packs for SharePoint 2010 available

The Norwegian version of SharePoint Server has been avaiable for some weeks, but the language packs have been missing. Often it is best (at least for the administrators) to run the server in english, and using language packs to give the end user/editors/super users the right language.



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


ULS Log Viewer application available for SharePoint 2007 og SharePoint 2010

I haven't seen this before today, but Microsoft released a great tool October last year: The ULS Log Viewer. A lot of features - inclduing real-time viewing of the logs => See the events as the occure! It works for both SharePoint 2007 and SharePoint 2010.

You'll find it here: http://code.msdn.microsoft.com/ULSViewer


Upgrading Content Types in SharePoint 2010

When you created Content Types solution in Visual Studio 2008 / SharePoint 2007 you very soon run into trouble when you were going to upgrade these content types with new fields. Code had to be writte :-)

This has now changed, and you will be able to to the same by adding the changes to the feature manifest:

The PushDown attribute on the AddContentTypeField action in the UpgradeActions element does the trick.

Setting up SmarterMail as a mailserver on a SharePoint 2010 demo machine

I basically followed Reza Alirezai's blog post, but remember the following:

  • Make sure you don't have domain/server name conflicts. I usually set up a mailserver on the address sharepointmail.local, and set this name to point to IP in the hosts file
  • Remember to set sharepointmail.local as the outgoing mailserver in Central Administration
  • Reporting Services use the Reporting Server config file and the SMTP server name has to be set to sharepointmail.local here as well. The correct config file is rsreportserver.config and is located in the folder C:\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\ReportServer
  • Define all the useres you need in SmarterMail setup and add the e-mail addresses to the your users in the User Profile store in SharePoint.

SharePoint 2010 and "There are no activities in your newsfeed" issue

These are the reasons I've found for why you don't get any activities displayed on the My Site page:

  • You have to start the "User Profile Service Application - Activity Feed Job", and schedule it to run periodically; Central Administration -> Check Job status -> Job Definitions. In my demo environment I set it to run often to make sure I can demonstrate it well.
  • Add some colleagues on your My Site
  • Make sure some activities have been performed by any of your colleagues

I don't think that the "Activity Feed Job" is turned on by default.


SharePoint 2010 RTM is finally here!

Downloaded it from msdn and installed it without any problems at all. Great work Microsoft. Before there always where issues to run into (especially when you run the "whole package" from one server), but this time it went a lot smoother althoug I got problems with the add-ons. I installed it on Microsoft SQL Server 2008 R2 CTP.

Services installed:
  • SharePoint base with all features
  • Excel Services
  • Reporting Services
  • Personalization services with my site and profile syncronization
  • Search
  • Visio Service
  • Secure Store Service
  • Managed Metadata Services
Complete SQL Server 2008 R2:
  • Database Engine
  • Reporting Services in SharePoint Integrated Mode
  • Analysis Services with the Adcenture Works databases (from Codeplex)

I'm currently struggling with the PowerPivot and the Reporting Services display:

  • Cannot add the PowerPivot package to the SQL Server .... several errors ... Gave it up for the time being! :-(
  • Cannot display reports created in the Report Builder and added to a document library... question asked in forum ... a strange url encoding error .... rsUrlRemapError :-(


Using a filter with a Excel Services and a Pivot parameter

I was going to create a BI dashboard containing a Pivot table from Analysis Services and some KPIs. The Pivot table sholud be rendered by Excel Services and the content should be filtered on the current user's country (region he/she was responsible for). The conuntry information was stored in the user profile. Straightforward - I thought, but oh no that was wrong ...

Everything was simple and easy until I was going to connect the Current User Filter web part to the Excel Services Web part and filter the pivot on the curent user's country. What I discovered after quite a lot of googling and reading different blog posts, was that a Analysis Services Pivot table parameter expect a value that is not a "simple" value as e.g. "Canada", but rather "[Geography].[Country].&[Canada]".

In my case then the Current User Filter Web part that comes OOB with SharePoint was not suitable, and I had to write my own. This filter wraps the user profile value into the correct Analysis Service Pivot parameter syntax.


Finalliy the SharePoint 2010 Ignite Online training has become available

SharePoint 2010 Ignite Online for IT Professionals
SharePoint 2010 Ignite Online for Developers

Now I don't have to book a whole week in Oslo (or somewhere else) to get the information, but download it and read it whenever I've time (e.g on the bus).

Material looks and presented by well known instructors.


SQL Server Analysis Servics vs Excel 2010 PowerPivot (and PowerPivot for SharePoint)

In a meeting with some BI/accounting specialists last week I was challenged with the following question:

  • You talk about Analysis Services, PowerPivot and PowerPivot for SharePoint, but what is right for us, and when to use which tool?

I'm not at BI / Analysis Services specialist, but I really would like to bring to the table some guidlines that both explains the different tools and when to use what. Luckily I didn't have to create this comparison myself - Microsoft have already done it.

It really depends on your focus:

  • Organisational BI => Analysis Services

  • Personal BI => PowerPivot

  • Team BI => PowerPivot for SharePoint 2010

Read the whole article:


Project 2010 together with SharePoint 2010 - a very good match

Project 2010 can now be used to syncronize tasks with SharePoint 2010. This is something that I think is great! The project leader can continue to do his/her planning in Project 2010, and when we collaborate during the project execution phase we work in a SharePoint team site. Great!

What if you participate in many projects and need to se all your tasks?



SharePoint 2010 My Site / My Profile Navigation and Menus Customization

Adding Links to the Top Link Bar on My Site / My profile:

Add links for every user

  • Manage Profile Service / My Site Settings / Configure Personalization Site

Add links for every user (must have access to the the my site hosting site collection):

  • Site Actions / Site Settings / Top Link Bar (under Look and Feel)

Add links to my own main menu (on my site):

  • Site Actions / Site Settings / Top Link Bar (under Look and Feel)

Adding menu pages to the My Profile Tabs (Documents, Overview, Organization, etc..)

  • Site Actions / Site Settings / Quick Launch (under Look and Feel)


I'm ready for the SharePoint 2010 certifaction run!

Finally I took the time to prepare myself and take the last SharePoint 2007 Certifaction: 70-542 Microsoft Office SharePoint Server Application Development. I'm very happy with a passing score of 960 (out of 1000) :-)

I'm ready for the 2010 run!


Creating custom web services in a SharePoint 2010 environment

I needed to write a custom web services to read and return all Term info based on a given Term name. I need that info to make adjustments to the File Classification Infrastructure scripts to upload files from the file system to SharePoint and set the correct Terms/Tags on the files.

Because SharePoint 2010 already are Ajax/Javascript enabled you don't need to make adjustments to SharePoint, but follow these very simple steps:

  1. Add a App_Code catalog to your web application, e.g. c:\inetpub\wwrwroot\wss\virtualdirectoris\80\App_Code
  2. Copy MySimpleService.asmx to c:\inetpub\wwrwroot\wss\virtualdirectoris\80 or to [14]/Template/Layouts/..
  3. Copy MySimpleService.asmx.cs to c:\inetpub\wwrwroot\wss\virtualdirectoris\80\App_Code
  4. Try your service: http://sharepoint2010/MySimpleService.asmx

That's it!

There are for certain issues, but it all depends on your scneario and what you need to do; KISS - Keep It Simple Stupid - but don't be stupid! :-) Of course you need to wrap-up and make a solution package of everything before you make it into a production environment...

Console Application, SharePoint 2010, accessing SPSite, and FileNotFoundException

When you try to open a site collection using new SPSite("") in e.g. a Console Application you get a FileNotFoundException - "The Web application at http://sharepoint2010/sites/development could not be found. Verify that you have typed the URL correctly. If the URL should be serving existing content, the system administrator may need to add a new request URL mapping to the intended application."

Then the first thing to check is that the Build Platform target is set to x64.

If that doesn't do it for you, thenn hopefully Google will find the anser for you.


SharePoint 2010 RC and Office 2010 RC are available on Microsoft Connect

and I'm going to test it a lot during the next few weeks/months. Avenir is in the Office 2010 PEP program, and I'm fortunate to be involved in a customer project. There is an NDA at work here so I guess it not much we'll be allowed post to the public.

Extending or upgrading your SharePoint 2007 farm to use Microsoft ASP.NET AJAX 3.5

Then check out Telerik's procedure (including a link to a complete solution/feature). http://www.telerik.com/help/aspnet-ajax/moss-install-aspnet-ajax-35.html

I've used both the solution and the step-by-step procedure with great success.


An old (or wrong) User Display Name is displayed in the Welcome message, Contact Box, etc in SharePoint 2007

Many, including me, has encountered the issue where a persons display name is not correct on a site (even if it iss correct in the User Profile) page. The unerlying cause of the issues is that for some reason the job that updates the user object cached in the site collection is not running at all or does'n do what it is supposed to do.

Below is how to fix "the effect" of the problem (we've not identified - yet - why the display name doesn't get updated at all) - how to force an update.

Important: This solution (as it involves deleting a person from the site collection) will cause the user to loose all priviliges and accesses. These have to be added back after the following steps are produced

  1. Make sure Display name in AD and SharePoint Central admin>Shared Services>user profile & properties> view user profile is same
  2. If Display name is not same that Click on Start full import.This imports the display name from AD to sharepoint.
  3. Got to top level site collection with admin priveledge
  4. Open the page http://servername/_layouts/people.aspx?MembershipGroupId=0 (all users in the site collection)
  5. Find your user, right click the name, and copy shortcut (url to the user's profile page)
  6. Paste the shortcut into the browser address field and append to it (don't hit enter yet): &Force=True (http://servername/_layouts/userdisp.aspx?Force=True&ID=25)
  7. Hit Enter
  8. Click on "Delete User from site collection" button on the toolbar
  9. Add the same user to (any group) in the Site Collection
  10. This time it will sync New display name from SSP
  11. Remove the user from the group (it's not needed anymore)
  12. Now the correct Display Name should appear where it should (Welcome message, Contact web part, User Picker, etc.)

Then I/we have to find out WHY the users in the site collection don't get updated as the should! :-(

Firewall Configuration and DMZ setup for an Internet Facing SharePoint 2007 site

I needed to identify and specify the firewall ports that needed to be opened for our internet facing SharePoint 2007 site. Simple configuration with a DMZ split in two subnets with a firewall inbetween.

Sources of information:


E-mail: Subject

E-mail: Body

Og det fungerer med e-post blogging :-)