Friday, April 20, 2012

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

While running a test from a project I've taken over, I get this error: 
Execution of user code in the .NET Framework is disabled. Enable "clr enabled" configuration option
My first thought is , "I thought the .NET Framework kinda *had* to run CLR code." Turns out the project is using .Net CLR inside the database. The error message wanted to be 
Execution of user code in the .NET Framework inside the database is disabled. 
Execute this TSQL:  "sp_configure 'clr enabled',1" and "RECONFIGURE"
So to fix this run this TSQL inside the database. 
sp_configure 'clr enabled',1
GO
RECONFIGURE
GO
sp_configure 'clr enabled'  -- make sure it took
GO
at

19 comments:

  1. Ashrafur Rahaman11:22 AM

    Helpful. Thanks.

    ReplyDelete
  2. Anonymous10:23 AM

    It did solved my issue .. many thanks..

    ReplyDelete
  3. Anonymous12:52 PM

    Solved my issue! THanks!

    ReplyDelete
  4. Anonymous7:10 AM

    Very Helpful. Solved the issue. Much clearer than the MS error

    ReplyDelete
  5. Sarbland12:18 AM

    Thank you! It works

    ReplyDelete
  6. Anonymous9:31 AM

    Thanks for the help!!

    ReplyDelete
  7. Anonymous11:00 AM

    It worked for me, thank you man

    ReplyDelete
  8. Anonymous12:46 AM

    Thanks!!..

    ReplyDelete
  9. Anonymous12:47 AM

    Thanks!!!... worked

    ReplyDelete
  10. Anonymous12:48 AM

    Thank You!!..

    ReplyDelete
  11. Anonymous3:02 AM

    Fantastic - very helpful!

    ReplyDelete
  12. m8:02 AM

    THNX

    ReplyDelete
  13. Unknown8:26 AM

    I solved my problem . Thanks fro the great answer. really appreciate it.

    ReplyDelete
  14. Anonymous5:55 AM

    Helpful, Thank you very much

    ReplyDelete
  15. Unknown1:14 PM

    Total thanks

    ReplyDelete
  16. Unknown3:05 AM

    It worked for me. Thank you very much.

    ReplyDelete
  17. Anonymous10:49 PM

    Thanks! It resolved my issue!

    ReplyDelete
  18. Anonymous9:47 AM

    It worked. Thanks a lot!!

    ReplyDelete
  19. alexandru.ispas1:27 PM

    Thanks. It worked for me.

    ReplyDelete