SharePoint (and Project Server) Shenanigans

I am a Project Server and SharePoint consultant but my main focus currently is around Project Server. I have been working with Project Server for nearly five years since 2007 for a Microsoft Gold Certified Partner in the UK, I have also been awared with the Microsoft Community Contributor Award 2011. I am also a certified Prince2 Practitioner. This article has been cross posted from pwmather.wordpress.com (original article)

Just a quick post as a reminder, I was recently at a client where projects failed to save to Project Server. The key error shown in Project Professional and in the Project Server queue was:

error id =”12005”

error= System.Data.SqlClient.SqlException: Execution of user code in the .Net Framework is disabled. Enable “clr enabled” configuration option

The error states the exact issue, CLR needed to be enabled on the SQL Server. The steps to enable CLR are documented here:

http://technet.microsoft.com/en-us/library/ee662108.aspx#section3