cancel
Showing results for 
Search instead for 
Did you mean: 

Windows Authentication to SQL server via OPA

johny-prentice
Deputy Chef II
Deputy Chef II

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.

1 ACCEPTED SOLUTION

johny-prentice
Deputy Chef II
Deputy Chef II

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. 

johnyprentice_0-1675714488315.png

 

View solution in original post

7 REPLIES 7

mroldanvega
Executive Chef I
Executive Chef I

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. 

mroldanvega_0-1674694009173.png

 

johny-prentice
Deputy Chef II
Deputy Chef II

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. 

johnyprentice_0-1675714488315.png

 

mschoen
Deputy Chef I
Deputy Chef I

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?