Skip to main content
  • EN

We are connecting to an SDE database via and SDE file in server, we would like to use Windows Authentication and the service account the server runs under. But when I load an SDE connection file with Windows Authentication selected it does not pick up the windows credtiasl of the service account.

 

Error Message:

Could not open the Enterprise Geodatabase. The error number from ArcObjects is: '-2147216118'. The error message from ArcObjects is: {Bad login user}

Please ensure the connection parameters are correct (server=`egisdev-db.tnad.tasnetworks.com.au', instance=`sde:sqlserver:egisdev-db.tnad.tasnetworks.com.au', user=`', password=`***', database=`EGIS_UNMaster', version=`sde.DEFAULT')

 

I have tried reading from the DB using a database connection set to Windows Authentication, but we need to to use SDE connection as these are esri geodatabases.

 

Any thoughts?

Hi @jackyd​:

  1. What version of FME are you using?
  2. I'm assuming you are trying to do this in FME Workbench and not in FME Flow?
  3. Can you confirm that you are using a Windows Authenticated Connection file (i.e. created with operating system authentication--ArcGIS Desktop, ArcGIS Pro)? If so, have you successfully connected to the geodatabase using this same SDE connection file with the Windows Auth. in ArcGIS, and on the same computer as FME?

Hi @jackyd​:

  1. What version of FME are you using?
  2. I'm assuming you are trying to do this in FME Workbench and not in FME Flow?
  3. Can you confirm that you are using a Windows Authenticated Connection file (i.e. created with operating system authentication--ArcGIS Desktop, ArcGIS Pro)? If so, have you successfully connected to the geodatabase using this same SDE connection file with the Windows Auth. in ArcGIS, and on the same computer as FME?

Hi @nampreetatsafe​ 

So it turns out the permissions on the db hadn't been granted for the user 🙂

Thank you fro your reply

 

Reply


Community Stats

30,108
Posts
114,295
Replies
37,745
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.