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.
After starting SQL Server, connect to the SQL instance and open a query window to 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