Markus' Blog

My thoughts and findings about Azure, Microsoft 365, SharePoint and SQL Server


SharePoint 2013 March Public Update released

Published at March 13, 2013 ·  1 min read

Microsoft released the March Public Update for SharePoint 2013 that is a prerequisite for all further updates: It can be found here: http://www.microsoft.com/en-us/download/details.aspx?id=36989 It is supposed to correct the problem with apps and non-default-zone addresses, and many others… Markus...

Extract .wsp files from SharePoint Config Database

Published at January 14, 2013 ·  2 min read

I recently had a customer with the need to extract a .wsp (SharePoint Solution) File from the SharePoint Farm Solutions because the source file disappeared mysteriously… As SharePoint loads the .wsp file into the config database (SharePoint_Config in most SharePoint environments – although it should be a name that you can recognize easily – you don’t name you files dok1, dok2, etc.) and stores it as binary content, it is not too hard to extract....

Cannot move video within SharePoint 2013 using drag & drop

Published at December 7, 2012 ·  2 min read

The new drag & drop functionality in SharePoint 2013 looks quite cool and seems to bring ease of use to everyone. Unfortunately this is again a feature that was not thought out: Moving around documents with the mouse works fine as long as you stay within the site. I tried this within an Assets Library – and everything was as expected except the fact that I could move an image but not a video!...

„HTTPResponseCode forbidden“ when using Office Web Apps 2013 with SharePoint 2013 over http

Published at November 20, 2012 ·  1 min read

It should be a security best practice to use Office Web Apps 2013 over https only. But just in case you want to use http (e.g. for a demo environment) you have to enable oAuthOverHTTP for your SharePoint 2013 Farm. Enter the following commands on your SharePoint Management Shell (not on the Web Apps Server): $config = (Get-SPSecurityTokenServiceConfig) $config.AllowOAuthOverHttp = $true $config.Update() Markus...

Open documents from file share with Office Web Apps 2013

Published at November 20, 2012 ·  1 min read

You can use the new Office Web Apps 2013 Server not only for opening/viewing documents from SharePoint 2013 but also to open files directly from a URL or a file share. The link has to look like the following: http://webappsserver/op/view.aspx?src=If you do not want to build the path manually, there is a web page that does the generation of the URL or the -Code for you: http://webappsserver/hosting -> redirects to: http://webappsserver/op/generate....

How to create a new GeoLocation field in SharePoint 2013 using PowerShell

Published at October 15, 2012 ·  1 min read

SharePoint 2013 has this new cool fieldtype called “GeoLocation”. This field allows us to save coordinates and show the location via Bing Maps: Unfortunately, this field type can only be created via Custom Code. One way is the Client Object Model, another one is PowerShell: $web=get-spweb http://sp2013 $list=$web.lists[“CustomList”] $list.fields.AddFieldAsXml(“”) $list.Update() You need to add a Bing Maps Key to your SharePoint Farm in order to be able to show geographical data using Bing Maps:...

Error: Controltemplate not found in ~/_controltemplates/<name-of-usercontrol.ascx>

Published at October 9, 2012 ·  1 min read

When creating a SharePoint Control with a ControlSrc pointing to a user control (for example to replace the SmallSearchInputBox), you might get an error in the ULS log saying that the control cannot be found in ~/_controltemplates/<name_of_usercontrol.ascx> although the file exists in the correct directory. This happens when using SharePoint 2013 and forget to add the correct SharePoint version to the path. In our case this should be ~/_controltemplates/15/<name_of_usercontrol.ascx> Markus...

SP 2013 Beta 2: Bug in Machine Translation/Word Automation/PowerPoint Automation Service - Service Application not available

Published at September 28, 2012 ·  1 min read

Machine Translation Services (as well as Word Automation Services and PowerPoint Automation Services) throw an Exception “Service Application is unavailable”, if the Application Pool Account of the Service Application does not have a local profile (Windows Profile, not SharePoint). The workaround is quite simple: log on as the Service Account on the SharePoint Maschine – or execute “runas /u:domain\appPoolAccount cmd”. Hopefully this will be fixed in RTM. Markus...

Dropdowns in ASP.NET Menu no longer working in IE10

Published at September 24, 2012 ·  1 min read

When upgrading my notebook to Windows 8 I encountered a strange behavior on opening an ASP.NET Web Application hosted on a Windows Server 2003. The dropdowns of the ASP.NET Menu Control didn’t work anymore. First, I thought this must be a problem of IE10, but this was only partly true. The problem is that the .browser files on the Web Server do not reflect the current versions. You could manually update the ie....