I am trying to use the Database Query component to connect to our Microsoft SQL instance and I am able to successfully enter the Connection URL but for username and password we use Windows authentication and not a username and password combo

Matillion ETL
1

Does Matillion have a way to recognize our local Windows authentication that we use to connect to our SQL instance?

2

Hey Joe!

 

Have you followed the steps in the documentation for Windows authentication, https://docs.matillion.com/metl/docs/2147237/#using-windows-authentication-with-an-sql-server-database? Let me know you get on!

 

Thanks,

Johnathan