I encountered this error while testing my CLR-PROC in Visual Studio. I got this error - Execution of user code in the .NET Framework is disabled. Enable "clr enabled" configuration option. After some research, I found out that in order to use CLR Function (located under database programability -> Assemblies, right click the assemblies and explore the dependencies), the CLR enabled configuration value need to change to 1. Here is how to change it by using sp_configure.
sp_configure 'clr enabled', 1
go
reconfigure
go
However, I was still having a little problem using the CLR function through Visual Studio. But after restarting the SQL server, it works!
No comments:
Post a Comment