Search Knowledge Base
KB #240116: Enabling CLR in a SQL instance for use with Encryptionizer SQL API’s
CLR is a more efficient method of executing NetLib SQL API’s than Extended Procedures. Below provides instructions on how to Enable CLR
For versions of Encryptionizer released after Jun 2014, if you use the Install API’s menu option, the utility will prompt to be able to enable CLR on the instance.
If you wish to do manually, use the following T-SQL script to enable CLR on the Server:
EXEC sp_configure 'show advanced options', 1; RECONFIGURE; GO EXEC sp_configure 'clr enabled', 1; RECONFIGURE; GO -- the next two lines are optional EXEC sp_configure 'show advanced options', 0; RECONFIGURE;
Important: You may need to restart SQL Server after enabling CLR, in particular SQL Express. If you continue to receive errors when adding the CLR APIs, restart SQL Server and try again.
240098: Col-E fails when selecting CLR User Defined Functions