When trying to deploy some CLR-code I get the following errormessage: "Common language runtime (CLR) execution is not supported under lightweight pooling".
After some research on the net I found a few links. They all stated I needed to run the following code:
Code:
EXEC sp_configure 'show advanced options' , '1';
go
reconfigure;
go
EXEC sp_configure 'lightweight pooling' , '0'
go
reconfigure;
go
EXEC sp_configure 'clr enabled' , '1'
go
reconfigure;
-- Turn advanced options back off
EXEC sp_configure 'show advanced options' , '0';
go
However, after successfully running this code I still kept receiving the same error. The solution was simple. The SQL-service must be stopped and started and after that, it all works like a charm.