ASP.NET CLR not enabled

Question

I get the following error on my new installation of ASP.Net and SQL Server when starting my application:

Execution of user code in the .NET Framework is disabled. Enable "clr enabled" configuration option 

I tried to fix this by doing this:

  use dasolPSDev; sp_configure 'clr enabled', 1 go RECONFIGURE go sp_configure 'clr enabled' go 

But then I get:

  Msg 102, Level 15, State 1, Line 3 Incorrect syntax near 'sp_config 

Answer 1

try it

 use dasolPSDev; EXEC sp_configure 'clr enabled', 1 go RECONFIGURE go EXEC sp_configure 'clr enabled' go 

Answer 2

A simplified version of the Jams solution that worked for me (SQL Server 2012):

 sp_configure 'clr enabled', 1 GO RECONFIGURE GO 

Source: http://msdn.microsoft.com/en-us/library/ms254506%28v=vs.80%29.aspx

Answer 3

I tried sp_configure @configname = clr_enabled, @configvalue = 1

and then restarted the sql server. he worked

Answer 4

I had a similar problem, but this works for me (SQL Server 2008 R2):

 sp_configure 'clr enabled', 1 GO RECONFIGURE GO 

Answer 5

EXEC sp_configure 'clr enabled', 1 go RECONFIGURE go