asp.netsql-serverclr

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

  • Try this

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