Question

FME error: rror connecting to instance 'sde:sqlserver:Server' for database 'database' on server '!not_used!' [closed]

  • 28 February 2019
  • 1 reply
  • 11 views

We are facing the error 

SDE_ERROR_CODE(-92) Bad connection handle
 while running the FME workspace via workbench.

Full error message:

Error connecting to instance 'sde:sqlserver:Server' for database 'database' on server '!not_used!' for user ''.:SDE_ERROR_CODE(-493)

 

Connection was attempted with an older version of SQL Server client communications software that is not supported.. Error connecting to instance 'sde:sqlserver:Server' for database 'database' on server '!not_used!' for user ''.:SDE_ERROR_CODE(-92) Bad connection handle.

Note: SQL native Client is SQL server 2012 native client and Microsoft system CLR types for SQL Server 2012.

We are facing this after we upgraded to FME 2016.1.2.1.

 

The workspace can run successfully in 2014 FME version.

Kindly suggest how to resolve this.

Lee!


1 reply

Badge +2

Hi @gaconvn1106, It appears that you might be using the Esri Legacy ArcSDE (Short name SDE30) reader. If that's the case, can you try using the Esri Geodatabase (ArcSDE Geodb) (Shortname GEODATABASE_SDE) reader instead, and see if the problem still occurs? Thank you!

Reply