Create an application partition for Microsoft SQL Server Always Encrypted

to segregate applications on the hsm, you must create an application partition specifically for your use case application partitions segment the permissions and keys between applications on an hsm choose one of the following methods to create an application partition excrypt manager perform the following steps on excrypt manager to create an application partition go to the application partitions menu and select \[ add ] in the basic information tab, configure all of the fields as follows option required configuration role name specify any name that you would like for this new application partition logins required set to 1 if the hsm is in fips mode, you must set logins required to 2 ports set to prod connection sources set to ethernet managed roles leave blank because you specify the exact permissions, key slots, and commands for this application partition or role to have access to use dual factor set to never upgrade permissions leave unchecked in the permissions tab, select the following key permissions permission description keys top level permission authorized allows for keys that require login import pki allows trusting an external pki generally not recommended, but some applications use this to enable pki symmetric key wrapping no usage wrap allows for interoperable key wrapping without defining key usage as part of the wrapped key use this only if you want to exchange keys with external entities or use the hsm to wrap externally used keys in the key slots tab, we recommend you create a range of 1000 total keys that do not overlap with another application partition within the specified range, you should have ranges for both symmetric and asymmetric keys if the application requires more keys, configure it accordingly to use the hsms' functionality, you must enable particular functions on the application partition based on application requirements microsoft sql always encrypted requires the following commands for operation enable the following commands in the commands tab pkcs #11 communication commands command description echo communication test/retrieve version hash retrieve device serial gpkm retrieve key table information gpks general purpose key settings get/change gpkr general purpose key settings get (read only) time get/set the hsm internal clock key operations commands command description grsa generate rsa private and public key rpfp get public components from rsa private key apfp get public components from ecc private key data encryption commands command description gpsr general purpose rsa encrypt/decrypt or sign/verify with recovery signing commands command description rsas generate a signature using a rsa private key asys generate a signature using pki private key fxcli run the following role fxcli commands to create the new application partition and enable all required functions fxcli role add –name role name –application –key range (0,999) –perm "keys\ authorized" –perm "keys\ import pki" – perm "keys\ no usage wrap" fxcli role modify name \[role name] add perm excrypt\ echo add perm excrypt\ hash add perm excrypt\ gpkm add perm excrypt\ gpks add perm excrypt\ gpkr add perm excrypt\ time add perm excrypt\ grsa – add perm excrypt\ rpfp – add perm excrypt\ apfp – add perm excrypt\ gpsr – add perm excrypt\ rsas – add perm excrypt\ asys