Skip to main content
Question

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

  • February 28, 2019
  • 1 reply
  • 74 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!

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

1 reply

xiaomengatsafe
Safer
Forum|alt.badge.img+11

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!