Failed to load encryption module

xu haung 1 Reputation point
2021-10-26T05:24:32.3+00:00

sqlserver 2014 configer ODBC link to DM database ：
msdasql back：Failed to load encryption module

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,706 questions
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Olaf Helper 40,741 Reputation points
    2021-10-26T06:10:34.853+00:00

    That's to less on information, you have to provide more details, like where and when do you get the error?

  2. Seeya Xi-MSFT 16,436 Reputation points
    2021-10-26T09:52:02.83+00:00

    Hi @xu haung ,

    Your linked server was created successfully but the connection test failed, this may be a permission issue. Also pay attention that your instance port is not blocked by the firewall.
    Check the following.

    • Whether the DM bin directory path is set in the system environment variable.
    • Whether the current user has the permission to access the files under the bin directory of the program, you need to add "EVERYONE" user to the bin folder under "Properties"-"Security"-and Grant "Full Control" permission
      Here is a video you can check MSDAINITIALIZE permission.

    Best regards,
    Seeya

    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
    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.

    0 comments