Question

SQL Server Spatial Error with upgrade to 2023.1

  • 1 December 2023
  • 2 replies
  • 39 views

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.

 

 


2 replies

Userlevel 3
Badge +16

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?

Badge +1

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