Is it possible to install multiple MS SQL EKM(Extensible Key Management) providers on a single MS SQL server instance ?

Garg Deepika 21 Reputation points
2020-09-30T07:07:47.947+00:00

An instance is created on MS SQL Server 2016 on Windows Server 2016 machine.

I want to configure multiple cryptographic providers on the same instance using copies of provider.dll stored at different locations on the same machine :

CREATE CRYPTOGRAPHIC PROVIDER safenetSQLEKM1
FROM FILE = 'C:\location1\provider.dll'

CREATE CRYPTOGRAPHIC PROVIDER safenetSQLEKM1
FROM FILE = 'C:\location2\provider.dll'

CREATE CRYPTOGRAPHIC PROVIDER safenetSQLEKM1
FROM FILE = 'C:\location3\provider.dll'

CREATE CRYPTOGRAPHIC PROVIDER safenetSQLEKM1
FROM FILE = 'C:\location4\provider.dll'

When I try to do the same, I get the below error message :

Cryptographic provider with guid '3746736F5-6A5E-4AE9-A131-27634875SD67' already exists.

Thanks in advance.
Regards

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,315 questions
0 comments No comments
{count} votes

Accepted answer
  1. CathyJi-MSFT 21,116 Reputation points Microsoft Vendor
    2020-10-01T09:38:22.913+00:00

    Hi @Garg Deepika ,

    > Is there any way to implement the above mentioned deployement?

    No. You can’t configure multiple cryptographic providers using same provider.dll file.

    Best regards,
    Cathy


    If the response is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


1 additional answer

Sort by: Most helpful
  1. Olaf Helper 39,181 Reputation points
    2020-09-30T08:05:57.783+00:00

    You can not register the same EKM provider several time, even if you locate them in different folders.

    EKM provider must be unique by it's GUID.