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

meghan-legaspi
Community Manager
Community Manager

Hi @johny-prentice,

I recommend reviewing this article: https://docs.microsoft.com/en-us/azure/active-directory/develop/v2-oauth2-client-creds-grant-flow#ge...

That resource was helpful to a few other members in the past.

@mppowe @susrith-kalluri @andrew-leung - any chance you have more advice?

Best,
Meghan

I dont think thats relevant to this topic.

mppowe
Executive Chef I
Executive Chef I

I don't have much to offer b/c I wasn't involved in the setup here.  If it helps any, the relevant block from our yml file has (with some changes of course), in the event that there's anything there that's helpful to you:

 

database:
  SqlDev:
    adapter: sqlserver
    host: servername.american.edu
    port: 1433
    database: development
    username: myWorkatoServiceAccountRunningTheWindowsService
    password: {encrypted: 'blahblah'}
    timeout: 30

That format looks exactly the same format as using  "SQL Authentication".