Unknown SQL Exception 297 occurred
While monitoring the ULS logs on a SharePoint 2010 server I could see the following message being logged every few minutes for each and every database: Unknown SQL Exception 297 occurred. Additional error information from SQL Server is included below. The…

AutoSPInstaller error – the tool was unable to install Application Server Role, Web Server (IIS) Role
I have just downloaded AutoSPInstaller 3.96 to install SharePoint 2013 onto a clean Windows 2012 R2 server but it fails to install the IIS role, generating the following error: WARNING: 2014-04-20 18:01:10 – Error: Unable to install (2) WARNING: 2014-04-20…

AutoSPInstaller GUI
For anybody that uses AutoSPInstaller I can highly recommend you download and use AutoSPInstaller GUI. It is a very simple and easy to use application that provides an interface for editing the autospinstallerinput.xml file. Here are some screenshots of it…
Change user display name using PowerShell
I have recently extended a web application to enable Form Based Authentication. After a few days I noticed that user display names are showing in the following format: i:0#.f|webbworldfbamembershipprovider|dave@webbworld.local I would prefer to see “Firstname Surname” format. To fix this I can user the Set-SPUser PowerShell command to change…

‘Could not execute CVTRES.EXE’ error when opening Site Web Analytics Reports
While trying to access the Site Web Analytics Reports page for a site I was presented with an error I hadn’t encountered before: An error occurred during the compilation of the requested file, or one of its dependencies. Could not…

Performing an in place upgrade of SharePoint 2010 Foundation to Standard
I have just performed an in-place upgrade of SharePoint 2010 Foundation to Standard 2010 and it was a fairly straight forward process. However if, like me, your SharePoint Foundation 2010 server was previously upgraded from WSS 3.0 then you’ll need…

Remove online presence information
If you are using Microsoft Lync in your organisation then user online status is shows on various SharePoint pages, and various actions are available. If you need to disable this feature then it can be done using Central Administration in…

PowerShell Script to list services running on all servers in a farm
I have written the following script to list the services running on each server in a SharePoint farm and their status, utilising the Get-SPServer cmdlet. <# ——————————————– SharePoint 2010 PowerShell script to list the services running on each server in…

Failed to connect to the configuration database when adding a server to a farm
While adding a new server to an existing SharePoint 2010 farm, to be used as a web front end (WFE) server, I encountered the following error: Failed to connect to the configuration database. An exception of type System.ArgumentNullException was thrown. …