Published on

SqlException: Execution of user code in the .NET Framework is disabled

Authors
  • avatar
    Name
    Jac Timms
    Twitter

We just migrated Kick News to new SQL Server 2008 database servers, everything went fine, but I'd missed one thing before we bought it back up and we were receiving the error "SqlException: Execution of user code in the .NET Framework is disabled".

It was an easy and very quick fix. Just run this and you should be fine again…

sp_configure 'show advanced options', 1;
GO
RECONFIGURE;
GO
sp_configure 'clr enabled', 1;
GO
RECONFIGURE;
GO

For further details see here