turns out the way to use windows authentication for odbc connection is through
`trusted_connection`
In Microsoft implementations, this user account is a Windows user account and NTLM authentication [MSDN-NTLM] is used when the value of the Trusted_Connection key is "Yes".