ASP.NET CLR Not Enabled
I am getting the following error on my new installation of ASP.Net and SQL Server when I run my app:
Execution of user code in the .NET Framework is disabled. Enable "clr enabled" configuration option
I have tried to fix it by running 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
Solution 1:
Try this
use dasolPSDev;
EXEC sp_configure 'clr enabled', 1
go
RECONFIGURE
go
EXEC sp_configure 'clr enabled'
go
Solution 2:
Simplified version of jams' solution which 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