SQL MI Auditing using ODBC module

[Gowtham SM]

Dear Team,

I am trying to configure auditing in Azure SQL  managed instance server as per below article,

https://docs.microsoft.com/en-us/azure/azure-sql/managed-instance/auditing-configure

But facing an issue that ALTER SERVER AUDIT statement cannot be used inside a user transaction though, I have mentioned commit as False in the playbook tasks. I have tried executing same from SQL studio with same user access and able to configure it successfully. Can someone please help how to fix this issue or any other alternate approach ?

I am using community.general.odbc module

Thanks & Regards,

Gowtham SM