I have the following scenario.
We use FME Form to gather public data. The data gathered should be written into a MSSQL database. Since we mainly work with ArcGIS Pro, and other ESRI products our MSSQL server has an SDE extension on it.
As long as I work in Form I can easily use sde connection files to access the databases. However, publishing a workspace utilizing an sde connection will result in errors since we do not have an ArcGIS Pro running on the same machine as our FME Server.
Until now I was using the reader and writer ‘ESRI ArcGIS Portal Feature Service’ but this is
- slow, and
- requires published feature services in the ArcGIS Enterprise portal.
I got our IT to open the firewall for direct access of FME Server to the MSSQL server and installed the latest msoledb drivers after getting the following error:
Microsoft SQL Server Spatial Reader: Failed to connect using Microsoft OLE DB Driver for SQL Server. Provider error '(-2147467259) Named Pipes Provider: Could not open a connection to SQL Server . '.
Unfortunately this did not do the trick and I am still getting the same error message.
What is it that I am missing here, or can I not use Microsoft SQL Server Non-Spatial format to connect to SDE-databases?