question

xuhaung-6291 avatar image
0 Votes"
xuhaung-6291 asked SeeyaXi-msft answered

Failed to load encryption module

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

sql-server-general
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

OlafHelper-2800 avatar image
0 Votes"
OlafHelper-2800 answered xuhaung-6291 commented

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

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.


like this ,but version sql 2008 is OK
143656-error.jpg


0 Votes 0 ·
error.jpg (819.8 KiB)
SeeyaXi-msft avatar image
0 Votes"
SeeyaXi-msft answered

Hi @xuhaung-6291,

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.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.