Skip to main content
Question

FME Server 2018 - Microsoft SQL Server - Provider error `(21) Encryption not supported on the client

  • June 3, 2019
  • 4 replies
  • 161 views

mferwerda3
Contributor
Forum|alt.badge.img+5

Has anybody seen this error before on FME Sever, any thoughts ?

FME Server 2018 - Microsoft SQL Server - Provider error `(21) Encryption not supported on the client

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

4 replies

siennaatsafe
Safer
Forum|alt.badge.img+12
  • Safer
  • 214 replies
  • June 7, 2019

Hello @mferwerda3,

I think it would be helpful to have a few more details. Where are you seeing this error on FME Server? Do you have a screenshot? Is this a new install?

Thanks!


mferwerda3
Contributor
Forum|alt.badge.img+5
  • Author
  • Contributor
  • 12 replies
  • June 11, 2019

Hi,

I got the IT folks to do some testing, and the issue occurs with the ms sql server client, without any interaction with FME, so it is a problem with our configuration, probably a m-s configuration of TLS someplace


steveatsafe
Safer
Forum|alt.badge.img+13
  • Safer
  • 422 replies
  • June 11, 2019

Hi,

I got the IT folks to do some testing, and the issue occurs with the ms sql server client, without any interaction with FME, so it is a problem with our configuration, probably a m-s configuration of TLS someplace

Thanks for giving us an update. I wanted to confirm this was the FME Server System Database you were attempting to configure? As you have discovered I doubt this supports encryption out of the box but it does raise a good point... can it support encryption? I don't have an answer to that at the moment.


mferwerda3
Contributor
Forum|alt.badge.img+5
  • Author
  • Contributor
  • 12 replies
  • June 11, 2019

It was not a FME server database, as in the core host DB that manages job history, fmw registration, etc, it is just a MS-SQL Server DB we are trying to write to using the MSSQL_ADO writer, the JDBC writer does work.