Azure Active Directory (Azure AD) authentication is now supported for SQL Server 2022 preview on-premises for Windows and Linux Operating Systems.

If azuread_administrator.azuread_authentication_only is set to true then values for administrator_login and administrator_login_password should not be required, plan and apply will succeed and the ...

A - Change the SQL server password from the portal and rerun bicep code with whatif, it doesnt detect the configuration drift and reports that the resources need no changes.

Using Azure's 'virtual machine agent,' you can reset the local administrator password without even hitting the Windows OS itself. Here's how.