KB #240028: How to Install Encryptionizer SQL APIs

Type:

Tip

Summary:

This article describes the steps needed to install APIs for Encryptionizer for SQL Server. If you are not able to install using the utility provided, you can install them manually

Additional Information:

During Installation:

When installing the Encryptionizer for SQL software, you are offered to install the Encryptionizer API’s at that time.

From the Main Menu:

If you did not install the API’s during the initiall software installation, you can install them with an option on the Main Menu. Open the Main Menu program (nlmenu.exe) and then choose:  Install/Update Encryptionizer API’s.

Manually:

There could be certain situations where these automated process may not be possible. In this case, you can follow this manual procedure for installing the APIs.

Using CLR (recommended for driver version 2010.201.10 or later)

Use of CLR style API’s results in faster results when running queries using Encryptionizer API’s. Additionally more complex diagnostic functions are available using CLR style API’s.

To install manually, open a query window to the SQL instance, connecting as a user with Sys Admin rights:

Enable CLR:

USE master
GO
EXEC sp_configure 'show advanced options' , 1; 
reconfigure;
GO 
EXEC sp_configure 'clr enabled' , 1 ;
reconfigure; 
GO

Next, Next, load and run this file (in the Master database) located in the Encryptionizer installation directory: add_udf_clr.sql

If you do not wish to keep CLR enabled, you can set ‘clr enabled’ to 0 and only enable when you  wish to run the diagnostic queries.

You must keep CLR enabled if using Column encryption.

Using Extended Stored Procedures (for versions older than 2010.201.10, not recommended for versions later)

Open a query window to the SQL instance, connecting as a user with Sys Admin rights

Run the following scripts (also found in the Encryptionizer install directory) in the listed order:

1. add_xp.sql
2. add_udf_xp.sql (SQL 2000 and later)
3. add_sp.sql (not included in all installations)

Related Topics:

240034: Error: Cannot resolve collation conflict for concatenation operation