Author Archives: Sven De Bont

About Sven De Bont

SharePoint & .Net developer Father of 2 Bruce Springsteen fan

Content By Query WebPart outputs incorrect url when there is no root sitecollection

If you have a webapplication with no sitecollection at the root url (e.g. all site collection are located under http:///sites/…) and you use the CBQWP to query for list items (events / tasks./ … anything but documents), you will receive a ‘404 page not found’ when clicking the link.

The CBQWP uses the CopyUtil.aspx page to redirect you to the item in question (see If there is no sitecollection at the root url, the site collection url will be missing from the url that is generated.

To solve this issue, edit the ‘ContentQueryMain.xslt’ file and change

<xsl:if test=”$UseCopyUtil = ‘True'”>
<xsl:value-of select=”concat(‘/_layouts/CopyUtil.aspx?Use=id&Action=dispform&ItemId=’,@ID,’&ListId=’,@ListId,’&WebId=’,@WebId,’&SiteId=’,$SiteId)”/>


<xsl:if test=”$UseCopyUtil = ‘True'”>
<xsl:value-of select=”concat($SiteUrl,’/_layouts/CopyUtil.aspx?Use=id&Action=dispform&ItemId=’,@ID,’&ListId=’,@ListId,’&WebId=’,@WebId,’&SiteId=’,$SiteId)”/>

SQL Server 2005 ‘Login failed’ (error 18456 state 16)

The event log of one of our SQL Servers filled up with events 18456 (every minute).

Failure Audit: Login failed for user ‘\’. [CLIENT:]

Looking in the SQL Server log, I found some extra information.

2011-10-18 12:52:00.55 Logon       Error: 18456, Severity: 14, State: 16.

I found this MSDN blog post, explaining most of the State codes, except for state 16.



2 and 5

Invalid userid


Attempt to use a Windows login name with SQL Authentication


Login disabled and password mismatch


Password mismatch


Invalid password

11 and 12

Valid login but server access failure


SQL Server service paused


Change password required

Digging a little further, I found that State 16 usually means that the target database cannot be located. I most cases, this is due to an SQL Server Job that targets a deleted of offline database.
Deleting or disabling the job gets rid of the errors in the event log.

Update Mango Beta 2 to RTM without restoring to NODO

Apparently, it’s possible to update your Windows 7 phone with the Mango Beta 2 installed to the RTM version of Mango without having to restore the NODO backup (and loosing all you have done since). Just update Zune to version 4.8, connect your phone and you will receive 2 updates. see

SharePoint 2007 workflow activities disabled in Visual Studio 2010 toolbox

Just noticed that when I tried to create a SharePoint 2007 workflow in Visual Studio 2010, the ‘SharePoint Workflow’ toolbox tab was missing. Selecting ‘Show all’ learned me that is was loaded, but they were all disabled.
As it turned out (after comparing the project file with another one where the toolbox was available) I was mssing a ProjectTypeGuid ({F8810EC1-6754-47FC-A15F-DFABD2E3FA90}) in my .csproj file

EDIT: a list of know ProjectTypeGuids can be found here: – Making SharePoint development a little easier

Just stumbled upon this nice little tool in the Visual Studio Gallery. It extends the default SharePoint 2010 intellisense schema in Visual Studio 2010 by adding xs:annotations elements and replacing xs:string types with enumerated types.
Download here:
The result:
Editing a FieldRef Element

Windows Search and Xml files

When you try to use Windows Search on the contents of xml files, you will find that not all text of an xml file is indexed.

For example, if you have the following xml file:


You will be able to find it by searching for “myelementext”, but searching on any of the terms below will fail

  • \
  • “\
  • %myelement
  • ?myelement
  • [<]myelement
  • xpath:\\myelement

Apparently, you can only search over the prefix of the term (ex: “test*”). With that said, the XML filter only outputs text terms within the XML document. (in our example only the terms myattrib and myelement are indexed). The other elements are attributes that are not typically user facing.

To have all text in an XML file indexed, we need to assign XML extension to use the plain text filter.
This is (currently) not possible with the UI, so you will need to modify the registry.

Navigate to HKEY_CLASSES_ROOT\.xml\PersistentHandler and change the default value to {5e941d80-bf96-11cd-b579-08002b30bfeb}

You will have to rebuild the index (Control Panel / Indexing options / Advanced / Rebuild)  to re-index the xml files.

Copy the lines below into a file with a .reg extension and double click to update the registry for you.

Windows Registry Editor Version 5.00

To verify that the ‘plain text filter’ is being used, go to ‘Control Panel’, ‘Indexing Option’. Select Advanced and on the ‘File Types’ tab, verify that the ‘Plain Text Filter’ is being used for the ‘xml ‘ extension

Note that you can also have other files (xsl, xslt, xsd, …) using the plain text filter by modifying the associated registry key
e.g. for xslt

Windows Registry Editor Version 5.00

For info on how to enable windows search in Windows Server 2008 (R2) see:

‘no connection’ when trying to view another user’s calendar – free/busy information (exchange 2010)

A while ago, the company I currently work for updated their servers to Exchange 2010. Ever since, I was unable to view other people’s calendar and free/busy information. The only error I got was a ‘no connection’ message in the calendar tab.

I was using Outlook 2010 on a computer that was NOT part of the domain.

When searching the internet, I noticed that I wasn’t the only one suffering from this behavior, but I couldn’t find an answer for the problem.

I turned on logging in Outlook (File – Options – Advanced – Enable troubleshooting logging) and found that the log file (%temp%\olkdisc.log) was filled with error from the Autodiscover service)


This led me to this Outlook 2007 article on TechNet which explains the relationship between the Autodiscover service and the Availability service:

The Availability service for Microsoft Exchange Server 2007 provides calendar information for your users. This information is known as free/busy information. The Autodiscover service provides information for the Availability service by locating and providing the external and internal URLs for the Outlook 2007 client. If your Microsoft Office Outlook 2007 users cannot view calendar information for other Outlook 2007 users in your Exchange 2007 environment, the problem may involve a failure in either the Autodiscover service or the Availability service.

The article provides the following steps to test the Autodiscover service (the article is for Outlook 2007, but the steps are the same for Outlook 2010):

    1. While Outlook 2007 is running, hold down the CTRL key, right-click the Outlook icon in the notification area, and then select Test E-mail AutoConfiguration.
    2. Verify that the correct e-mail address is in the box next to E-mail Address.
    3. Clear the check boxes next to Use Guessmart and Secure Guessmart Authentication.
    4. On the Test E-mail AutoConfiguration page, verify that the check box next to Use AutoDiscover is selected, and then click the Test button.

I my case, the test failed because of the Autodiscover services could not be reached.

As it turned out, the Proxy server could not reach the Autodiscover service. I used Internet Explorer to add the url to the ‘Local Intranet’ zone, so the proxy server would be bypassed and everything worked perfectly.

Reflector Alternatives

Now that reflector is no longer a free tool (see, alternatives are gaining popularity.

2 promising alternatives are ILSpy (, an open source initiative that initiated after the announcement by Red-Gate, and dotPeek ( a free tool by JetBrains, the same people that brought us ReShaper.

IE8 Developer tools opening automatically when opening new tab

Got an annoying issue today. Whenever I opened a new tab in Internet Explorer (IE8), a new instance of the ‘Developer tools’ would open automatically. Normally, when you close them, they shouldn’t reopen again until you explicitly want to.

The result was after opening 6 or 7 tabs, there would also be 6 or 7 instances of the developer tools.

I tried turning the off and closing IE, even rebooting, but they would keep ‘popping’ up.

Eventually, I managed to get rid of them by doing the following

1. Open the registry editor
2. Navigate to HKEY_CURRENT_USER\Software\Microsoft\Internet Explorer\IEDevTools
3. Set the value of the key ‘Pinned’ to ‘1’ (REG_DWORD)
4. Open IE – this loaded the developer tools to, but they were pinned (embedded) in the browser window
5. close the developer tools while embedded

This FINALLY prevented the developer tools from being loaded with every tab I openened.

meh :/