SQL Query with Windows Authentication

Robert Pincus

July 25, 2017 20:57

Hi,

 

I am trying to use the SQL Query activity to connect to a database with Windows Authenication. When I run the workflow in the simulator, it run fine. However, when I run the workflow within a site, a get this error. "Login failed for user 'RIVCOCA\APD01$'", where RIVCOCA is the domain and APD01$ is the machine name. How can I get the workflow to run within the site?

 

Thanks,

 

Robert

0

• 

  Mike Ketler

  July 26, 2017 19:04

  Hi,

   

  Server side workflow activities like "SqlQuery" are run by the REST IIS Application Pool. By default this Application Pool uses the ApplicationPoolIdentity which is why you are seeing the domain\computer name. You can either get your IT team to configure permission for the computer domain identity or you can change the IIS Application Pool to use a domain service account. See attached screenshot.

   

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

   

  Thanks,

   

  Mike Ketler

  0
• 

  Robert Pincus

  July 31, 2017 21:13

  I did what you suggested, and set the application pool to use me and I was able to run a SQL query. I will go ahead and get a domain account set up and use that instead.

   

   

  0

Please sign in to leave a comment.