Configure EKM in Microsoft SQL Server

this section shows how to enable ekm in microsoft sql server and register the fxcl ekm provider enable the ekm provider option to use the fxcl ekm provider, perform the following steps to enable the ekm provider option on the sql server before proceeding open the sql server management studio application connect to the sql server open a query window and execute the following commands sp configure 'show advanced', 1 go reconfigure go sp configure 'ekm provider enabled', 1 go reconfigure go register the provider perform the following steps to register the fxcl ekm provider open a new query window in sql server management studio and execute the following commands create cryptographic provider fxclekmprovider from file = 'c \program files\futurex\fxcl\kmes\ekm\libfxcl ekm dll'; go