Knowledge Base

KB #240098: Col-E fails when selecting CLR User Defined Functions

Type:

Information

Summary:

In order to use CLR User Defined Functions (UDF) in Column Encryption, you must enable CLR on the Server.

Additional Information:

For version 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.

Last modified: 7/8/2016