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.

[meghan-legaspi]

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

[johny-prentice]

I dont think thats relevant to this topic.

[mppowe]

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

[johny-prentice]

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