Skip to main content
Question

Arc SDE Connetion issue for Sql server

  • August 13, 2014
  • 4 replies
  • 122 views
C
hi ,

 

i am getting below error while connecting SQL Server from FME desktop ,

 

 

Making a direct connection using instance 'sde:sqlserver' and userId = 'username'

 

Error connecting to instance 'sde:sqlserver' for database 'sde' on server '!not_used!' for user 'eifme'.:SDE_ERROR_CODE(-324) Cannot connect to database because the database client software failed to load.  Be sure the database client software is installed and configured correctly.. Error connecting to instance 'sde:sqlserver' for database 'sde' on server '!not_used!' for user 'eifme'.:SDE_ERROR_CODE(-92) Bad connection handle

 

 

Currently using Arcgis 10.2.1

 

 

 

any idea...

4 replies

david_r
Celebrity
  • david_rCelebrity
  • August 14, 2014
Hi,

 

 

make sure you have installed the SQL Server native client (http://msdn.microsoft.com/en-us/sqlserver/ff658533) on the desktop in question.

 

 

David
C
  • cng
  • Author
  • August 15, 2014
HI David,

 

we have installed SQL server in FME desktop machine already, we are able to connect using ArcCatalog using direct connection but when we tried on FME geting above mentined error , 

 

 

 
C

any update? facing the same issue. I can connect using arcmap but when running a job from fme server I encounter the same error.

Error connecting to instance 'sde:sqlserver:hostname' for database 'xxx' 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:icmsgisdb.icmsdev.com' for database 'ICMSGIS' on server '!not_used!' for user ''.:SDE_ERROR_CODE(-92) Bad connection handle

C
chiaweijie1000 wrote:

any update? facing the same issue. I can connect using arcmap but when running a job from fme server I encounter the same error.

Error connecting to instance 'sde:sqlserver:hostname' for database 'xxx' 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:icmsgisdb.icmsdev.com' for database 'ICMSGIS' on server '!not_used!' for user ''.:SDE_ERROR_CODE(-92) Bad connection handle

I get the same error be in running from FME bench or from the server straight. I am using sql server 2012 with arcgis 10.4.1 installed in the same server. FME server is win32

 

 

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.