Skip to main content
  • EN
  • Home
  • Forums
  • FME Form
  • Data
  • FME SQL Server Reader failing to connect . how do I check if this is a client issue? The DB is 2019 SQLServer.

error ( Microsoft SQL Server Spatial Reader: Failed to connect using Microsoft OLE DB Driver for SQL Server. Provider error '(-2147467259)). FME server version FME Server 2022.2 Build 22765 - win64, works on desktop with same SQLServer credentials

https://community.safe.com/s/question/0D54Q000080h953SAA/microsoft-sql-server-spatial-reader-failing maybe this helps? looks like your not alone

 

@j85824​ dependencies for the SQL Server Reader/Writer can be found below. Check if the machine hosting your FME Server engines has the OLE DB Driver 19.x installed. If not, you can download it from Microsoft and install it.

https://docs.safe.com/fme/html/FME-Form-Documentation/FME-ReadersWriters/mssql_spatial/mssql_spatial.htm

Reply


Community Stats

30,351
Posts
115,342
Replies
38,082
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.