Database
Microsoft SQL Server
Configuring EKM on the Microsoft SQL Server
3min
perform the following tasks to configure ekm enable the ekm provider option register the fxcl ekm provider enable the provider option to use the fxcl ekm provider, perform the following instructions to 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 provider 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 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