Search Knowledge Base
KB #240028: How to Install Encryptionizer SQL APIs Manually
This article describes the steps needed to install APIs manually for Encryptionizer for SQL Server.
Normally, Encryptionizer SQL APIs can be optionally installed during initial software installation. They can also be installed by running the Install APIs Utility (XPADMIN.EXE) included with Encryptionizer. However, there could be certain situations where this 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:
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
Using Extended Stored Procedures (for versions older than 2010.201.10 or those that do not want to enable CLR)
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:
- add_udf_xp.sql (SQL 2000 and later)
- add_sp.sql (not included in all installations)
240034: Error: Cannot resolve collation conflict for concatenation operation
Last modified: 10/4/2018