← Back to Knowledge Base

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

⏱️ 1 min read

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.

Was this article helpful?

Related Articles

KB #240058: Event ID for the system log entries for nlemsql are “not found”

Type: Known Issues Summary: You have secured your SQL instance with Encryptionizer and have selected…

KB #240067: Using 3GB Switch in BOOT.INI may cause I/O errors (event ID: 1181)

Type: Information Summary: Using the 3GB switch in boot.ini will severely restrict kernel memory and…

KB #240053: SQL Server or encrypted databases not accessible after configuring Encryptionizer

Some explanations of why SQL Server may not start after installing and configuring Encryptionizer for…

Still need help?

Our support team is here to assist you.

NetLib Security
AI Assistant · Online
Hi! I'm the NetLib Security assistant. I can answer questions about our encryption solutions, HIPAA compliance, Encryptionizer, and more. How can I help you today?