Skip to main content

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

Thanks!

Hi, The IT department got back to me quicker than I thought and I figured I would post the solution here in case anyone else runs into this problem. You need to update the sql native client. This is what my IT department said to me specifically:

 

"this wasn't specific for FME but it was the same error.

Solution / Workaround

 

If you use TLS 1.1 or 1.2 as default secure protocols instead of TLS 1.0 and use older release of SQL Server Native Client 2012 then this issue can occur. This will result in unusable vault as M-Files services won't be able to communicate with MS SQL server and will result in failing to bring the vault online.

 

 

You must update your SQL Server Native Client to build 11.3.6538.0 or higher for enabling support for TLS 1.1 and 1.2. Older versions don't support TLS 1.1 or TLS 1.2. "

 

IT updated us to 11.4 and FME could use the readers again.


Reply