Hi FME Community,
I am moving some FME workbenches from a 2012 microsoft server to a 2019 microsoft server and am finding some issues with running a few of them. The person who originally set up the workbench I am trying to get to run is no longer with the company and I arrived after they left.
I am trying to read in table features on a MSSQL_ADO reader and keep running into this error:
Provider error `(-2147467259) Encryption not supported on the client.'
Failed to open reader
I am thinking it has to do with the new server or some configuration that needs to be done somewhere.
I have found a few leads
- https://knowledge.safe.com/questions/93143/fme-server-2018-microsoft-sql-server-provider-erro.html
- This one was answered by the questioner but they did not say how they fixed the error besides it being a configuration issue
- In the admin guide https://docs.safe.com/fme/pdf/FME_Desktop_Admin_Guide.pdf I have found at the bottom of page 37/beginning of page 38 something more promising
- I am currently waiting to hear back from our IT department but I was wondering if anyone else had run into this issue and had solved it before or if I am missing something here?
Thanks!