How to use Windows Authentication in Database Connector with Microsoft SQL Server in Mule4

Very simple solution:

Add DB connection property after creating a generic MS SQL connection.

Just add listed DB connection property XML tag(s) in the DB config tag.

<db:config name=”Database_Config” doc:name=”Database Config” doc:id=”068171dd-d96f-4eeb-8376-0326746ae25d” >
<db:mssql-connection host=”HOST_IP_NAME” user=”USER_NAME” password=”PASSWORD” databaseName=”DATABASE_NAME“>
<db:connection-properties>
<db:connection-property
key=”authenticationScheme” value=”NTLM” />
<db:connection-property key=”domain” value=”DOMAIN_NAME” />
<db:connection-property
key=”integratedSecurity” value=”true” />
</db:connection-properties>
</db:mssql-connection>
</db:config>