Skip to main content
Question

SQL Server Spatial Error with upgrade to 2023.1

L

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

ctredinnick
Supporter
Forum|alt.badge.img+18
  • ctredinnickSupporter
  • Supporter
  • December 1, 2023

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?

peteratqfes
Contributor
Forum|alt.badge.img+6
  • peteratqfesContributor
  • Contributor
  • December 3, 2023

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


Helpful Members This Week

Community Stats

31,139
Posts
118,062
Replies
38,758
Members

Latest FME

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie 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.