I am trying to create a a stored procedure in SSMS that makes use of CLR. I don't think the script matters, because it works on other machines. The error I'm receiving is:
Msg 10335, Level 16, State 0, Procedure Usp_CreateGISEvent, Line 19 [Batch Start Line 12] The Common Language Runtime (CLR) was loaded in an unsupported manner. This can occur if an extended stored procedure or OLE Automation object running in SQL Server calls into managed code before the CLR integration runtime host loads the CLR. You need to restart SQL Server to use CLR integration features.
I enabled CLR settings via
EXEC sp_configure 'clr enabled', 1;
RECONFIGURE;
Then restarted the SQL server.
However, when I run select * from sys.dm_clr_properties
the state value is still "CLR is not loaded by SQL Server's CLR hosting code".
What should I look for?
Thanks in advance