cancel
Showing results for 
Search instead for 
Did you mean: 

Windows Authentication to SQL server via OPA

johny-prentice
Deputy Chef I
Deputy Chef I

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.

5 REPLIES 5

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
Deputy Chef III
Deputy Chef III

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".