Using EKM Provider with Multiple SQL Instances

Different SQL instances can use different properties file.

For different SQL instances to use the SafeNet ProtectApp MSSQL EKM Provider, go to the installation directory of EKM and copy the safenetsqlekm.dll, IngrianNAE.properties, and config.txt files at the desired location.

Now, load the cryptographic provider from this new location using the following statement:

CREATE CRYPTOGRAPHIC PROVIDER <provider_name>
FROM FILE ='<new_location>'

The IngrianNAE.properties file must be placed in the same folder where provider DLL is copied. For one instance of database server only one library and property file can be used.