data connection - Use Windows Authentication

Dan Griffin

7. August 2014 23:43

Hi, I'm trying to set up a data connection using Windows Authentication but Manager isn't respecting my login?  When I try to connect to the database I get this error:

DataConnection '': Unable to establish a connection for DataConnection ''. [DataConnection '': "The connection string of DataLinkConnectionItem '' is invalid. [Login failed for user 'DS\ARCGIS$'.]]

However, DS\ARCGIS$  isn't a windows login and not the user I'm logged into Manager as?  Any idea where this is comming from?

 

Thanks,

Dan   

 

0

• 

  Kari Randall-Secrest

  21. August 2014 01:18

  Dan - Did you get this figured out?  I'm getting a similar error.

  Kari

  0
• 

  Dan Griffin

  25. August 2014 22:20

  No, unfortunately not.  I had to create a local login in the DB.

  0
• 

  Permanently deleted user

  29. Mai 2015 02:28

  Kari...did you have any success with this issue. I'm having the same problem.

  Thanks

  Simon

  0
• 

  Kari Randall-Secrest

  29. Mai 2015 02:52

  Hi Simon,

  No, unfortunately.  I got busy with other things and just hadn't had a chance to get back to it and try it again.

  Kari

  0
• 

  Permanently deleted user

  9. September 2016 19:20

  Hi, 

   

  If you are experiencing problems establishing a data connection to a database that is using Windows Authentication, then please go to IIS Manager > Application Pools > EssentialsAdministrationAppPool4 > Advanced Settings > Identity and add a custom account. Essentials uses the Application Pool Identity for authentication (which is why the server name shows up in the error message). By adding a custom account, Essentials will now use that account for authentication when sending requests to other servers.

   

  After you have added the account to EssentialsAdministrationAppPool4, please do the same thing to EssentialsAppPool4. Once this is all done, re-run the Post Installer to update the changes and you should be able to create the data connection in Essentials Manager. 

   

  I hope this helps.

   

  Carmen

  0
• 

  Permanently deleted user

  11. Mai 2017 13:43

  Carmen, 

   

  what user should I use in the custom account if I want the applicaiton to use which ever user is logged in to make the connection to the database? 

   

  Tom 

  0
• 

  Permanently deleted user

  23. Mai 2017 21:19

  Hi Thomas,

   

  In the Data Connection properties in Manager, there is an option to act as the connected Windows user.  That should do the trick!

   

  Thanks,

   

  Danny

  0
• 

  Permanently deleted user

  2. Oktober 2017 21:43

  Daniel,

   

  I don't see this option? Can you please be more specific?

   

  _img_ alt="User-added image" src="https://latitudegeo--c.na53.content.force.com/servlet/rtaImage?eid=907f2000000fxuK&feoid=Body&refid=0EMf2000000kA29" _/_img_

  0
• 

  Permanently deleted user

  19. Oktober 2017 22:51

  Hi Melanie,

   

  I'm afraid I made a mistake, I was thinking of the map service connections.  To my knowledge, you cannot have a data connection act as the connected user, since connects with the App Pool identity (as Carmen mentions earlier in this thread).  

   

  Sorry about that!

   

  Thanks,

   

  Danny

  0

Bitte melden Sie sich an, um einen Kommentar zu hinterlassen.