ASP.NET CLR Not Enabled
73,564
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
Solution 3
I had a similar issue, but this works for me (SQL Server 2008 R2):
sp_configure 'clr enabled', 1
GO
RECONFIGURE
GO
Author by
cdub
Updated on January 17, 2020Comments
-
cdub over 4 years
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
-
mithilatw over 10 yearsHow long does this script normally take to execute? because mine, I have had it run more than 1 minute and still no result..!!
-
ganesh almost 5 yearsHow to run this