Windows Authentication to SQL server via OPA

[johny-prentice]

Has anyone got this working... ? 

Can you please assist me with how you set this up.

Theres no documentation and support have struggled to provide a clear answer.

[mroldanvega]

You need to also add the 'authentication' property, either Active Directory Password or in your case to use Windows Authentication you need to enter Integrated Authentication. Please also remember you need to set the LogOn credentials on the Windows Service (OPA) so that it can successfully work. 

[johny-prentice · Accepted solution]

My main issue was the "OPA" was setup as cloud.
So it ignores any profile you setup in the config file on the OPA server.

I think this is new feature, that a lot of people aren't aware of. 

[mschoen]

So that means in the Set-up connection i can't use "Directly in Workato", when I need to work with a Windows authentication, right?