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

Search Knowledge Base

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

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.

Knowledge Base

Search Knowledge Base