Configuring EKM on the Microsoft SQL Server

perform the following tasks to configure ekm 1 | enable the ekm provider option to use the fxcl ekm provider, the ekm provider option must first be enabled on the sql server open the sql server management studio application connect to the sql server open a query window and execute the following sp configure 'show advanced', 1 go reconfigure go sp configure 'ekm provider enabled', 1 go reconfigure go 2 | register the fxcl ekm provider open a new query window in sql server management studio and execute the following create cryptographic provider fxclekmprovider from file = 'c \program files\futurex\fxcl\kmes\ekm\libfxcl ekm 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