I was testing our new SQL Server 2008 enterprise cluster today and managed to get the following SqlException running a C# application:
"Execution of user code in the .NET Framework is disabled. Enable "clr enabled" configuration option.
The statement has been terminated."
The solution is to run the following:
EXEC sp_configure 'show advanced options', '1' ;
go
RECONFIGURE ;
go
EXEC sp_configure 'clr enabled', '1'
go
RECONFIGURE ;
-- Turn advanced options back off
-- EXEC sp_configure 'show advanced options' , '0';
GO
Pluralsight & Packt Author, Director, CTO, Software Architect, Team leader, Tutor, Speaker, Software Developer. I like to make fast scalable things using C# and SQL Server.
Tuesday 29 September 2009
Friday 25 September 2009
Web Deployment Tool 1.0 has shipped
Subscribe to:
Posts (Atom)