← Back to Knowledge Base

KB #240116: Enabling CLR in a SQL instance for use with Encryptionizer SQL API’s

⏱️ 1 min read

Type:

Information

Summary:

CLR is a more efficient method of executing NetLib SQL API’s than Extended Procedures. Below provides instructions on how to Enable CLR

Additional Information:

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.

Related Topics

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

Was this article helpful?

Related Articles

KB #240145: Determine Current Encryptionizer Driver Information

Type: Info Summary: Most features, updates and improvements are based upon the version of Encryptionizer…

KB #240008: How to access encrypted databases on a RAW Volume

Type: Information Summary: This article explains how to allow SQL Server to access encrypted databases…

KB #240091: NLCBTASK Service fails to start with error “The system cannot find the file specified”

Type: Fix Summary: The installer added the ImagePath for the NLCBTASK Service without surrounding quotes. This…

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?