Configuring EKM on the SQL Server

this section shows how to enable ekm on the sql server and register the {{futurex}} ekm provider enable the ekm provider option to use the {{futurex}} ekm provider, you must enable the ekm provider option on the sql server 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 futurex ekm provider open a new query window in sql server management studio and execute the following command create cryptographic provider futurexekmprovider from file = 'c \program files\futurex\fxekm\fxekm dll'; go if you encounter the error, cannot initialize cryptographic provider provider error code 1 (failure consult ekm provider for details) , perform the following steps switch the server authentication type to windows authentication right click the db server, select properties , and go to the security tab change the server authentication type from sql & windows authentication to windows authentication