Self Service Site Creation failed with permission error

After activating self service site creation for a Web Application creating new site collections thru http://WEPAPP/_layouts/scsignup.aspx failed with a permission error


  1. Go to Central Administration -> Application Management -> Manage Web Applications
  2. Select the My Site Web Application, then click “User Permissions” in the Ribbon
  3. Scroll down to the Site Permissions section and UNCHECK “Use Self-Service Site Creation” then click Save at bottom
  4. Make sure the My Site Web Application is still selected and go back into “User Permissions”
  5. RE-SELECT “Use Self-Service Site Creation” and Save

Null Values in SQL Server Management Studio

Just a reminder: To set Null-Values in a field press CTRL+0.

Office Developer Tools for Visual Studio 2012 and Workflow Manager / Service Bus

A while ago Microsoft has released the “Office Developer Tools for Visual Studio”. If you’re installing those tools in a Microsoft SharePoint 2013 environment the installer also will update the “Service Bus” and “Workflow Manager” to CU 1. If you can remember, you have to install those components under the WF Account. Same goes for the update.
Install the developer tools under the WF Service Account and it will run fine. Otherwise the update will fail.

Connect to the SharePoint Integrated Database


You have installed SharePoint with the integrated Database option. You now want to connect to the databaseserver but are getting error messages.




as Servername in the connection dialog.

Slipstream SharePoint 2010 SP1

To safe time for new SharePoint Installations it’s a common way to integrate released service packs and CU’s to the rtm disc set. The process is very similar to the 2007/WSS 3.0 process. It’s recommended that you also integrate the foundation SP even if you use SharePoint Server. If you only use foundations you can skip the server download.

Slipstream SP1 (Foundation & Server)
  1. Extract the Server or Foundation ISO disc image
  2. Download SP1 for Foundation
  3. Download SP1 for SharePoint Server
  4. Locate the “update” folder of the extracted iso image
  5. Extract the foundation service pack to the update folder (in my case it’s located at D:\SPISO\EN\Updates)
    sharepointfoundation2010sp1-kb2460058-x64-fullfile-en-us.exe /extract:D:\SPISO\EN\Updates
  6. Extract the SharePoint Server service pack to the update folder
    officeserver2010sp1-kb2460045-x64-fullfile-en-us.exe /extract:D:\SPISO\EN\Updates
  7. Done. If you install SharePoint Server the update folder will automatically applied.

You can skip step 3 and 6 if you only have a foundation installation.

Failure trying to sync site for ContentDB WebApp , Event ID 5553

Periodical errors in the event log of a SharePoint 2010 server with the following error event descriptions:
Failure trying to synch site <ID> for ContentDB <ID> WebApp <ID>. Exception message was Cannot insert duplicate key row in object 'dbo.UserMemberships' with unique index 'CX_UserMemberships_RecordId_MemberGroupId_SID'. The statement has been terminated.

Old references to non existing content databases in the synchronization job list.

List databases which are not synced for more than two days
stsadm -o sync -listolddatabases 2

Delete old database references from the config db
stsadm -o sync -deleteolddatabases 2


How to change the webaddress of a sharepoint library in SPS 2010

  1. Open SharePoint Designer 2010 and open the site with the library
  2. Click on [All Files] Link
  3. Select the desired library (PublishingImages in this example)
  4. Rename it

Yes, it is that simple.

SharePoint Technical Libraries

70-667 and beyond

A while ago a participated in the beta exams for 70-667 (TS: Microsoft SharePoint 2010, Configuring).
The exam contained about 70 Question about

  • Backup & Restore
  • Policies
  • Monitoring
  • Upgrading
  • Service Applications
  • Solutions
  • Application Management (AAM, Content Databases, host headers)

More information about the measured skills can be found on the Microsoft Learning Site.
The exam was quite doable if you have played around a little with the Beta and RTM versions of SPS 2010. Experience in MOSS 2007 wouldn’t also do any harm.

Because it was a beta exam cycle i didn’t get any results after finishing the exam.
Nevertheless last weekend i’ve got the confirmation mail from Microsoft which means…… i’m one of the first MCITP’s for SharePoint 2010 – at least in germany. 😉

Quick Backup & Restore with ‘sp_MSForEachDB’

Another undocumented SP in Microsoft SQL Server is the ‘sp_MSForEachDB‘ procedure. This procedure enumerates every database on a Microsoft SQL Server Instance and let you perform different actions on every database. This can be quite useful in several situations. For example the following two scripts are

  • creating database backups of  all databases on a SQL Server Instance
  • creating a restore script for those databases

To use those scripts you may want to modify the paths  (‘c:\#Backup’, ‘C:\MS SQL Data\MSSQL.1\MSSQL\Data\?.mdf’,….) to match your environment:


 'IF DB_NAME((SELECT dbid FROM sysdatabases WHERE [Name]= ''?'')) NOT IN (''tempdb'',''master'',''model'',''msdb'')
 N''?-Full Database Backup'', SKIP, NOREWIND, NOUNLOAD'


'IF DB_NAME((SELECT dbid FROM sysdatabases WHERE [Name]= ''?'')) NOT IN (''tempdb'',''master'',''model'',''msdb'')
 MOVE N''?'' TO N''C:\MS SQL Data\MSSQL.1\MSSQL\Data\?.mdf'',
 MOVE N''?_log'' TO N''C:\MS SQL Data\MSSQL.1\MSSQL\Data\?.ldf'',