Skip to main content
  • EN

We have upgraded to FME FLOW 2023.1.

Now the workbenches that write or read to to our SQL Server Spatial - SDE MS SQL Server 2012 fail.

It looks like an SSL certificate error.

 

Microsoft SQL Server Spatial Writer: Failed to connect using Microsoft OLE DB Driver 19 for SQL Server. Provider error '(-2146893019) SSL Provider: The certificate chain was issued by an authority that is not trusted. '. Connection string 'Provider=MSOLEDBSQL19;Data Source=djskfjdksfjslfjslf-sqlserver-se.cdvhtvcfec0o.ap-southeast-2.rds.amazonaws.com;Initial

 

Failed to open writer MSSQL_SPATIAL writer: An error has occurred. Check the logfile above for details.

 

Not sure what is going on and how to fix it. The workbenches on FME Form fail as well with the same error.

 

 

The microsoft SQLSysClrTypes.msi used to be a separate install required for SQL spatial, but I think in 2023 it now comes packaged with the FME install. Maybe there's something invalid there, try download/install it yourself?

Could it have anything to do with the organisation having a custom SSL certificate store?  ieThe certificate chain was issued by an authority that is not trusted.

Reply


Community Stats

30,351
Posts
115,341
Replies
38,080
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.