Using EKM Provider with Multiple SQL Instances
Different SQL instances can use different properties file. This will enable you to use separate CipherTrust Manager for different SQL instances.
To use this with the CAKM for Microsoft SQL Server EKM Provider, go to the installation directory of the provider and copy the cakm_mssql_ekm.dll, and cakm_mssql_ekm.properties 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>'
Note
The cakm_mssql_ekm.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.
