Hi,
I’m trying to connect to an azure sql server database with geoserver. Multifactor Authentication is required, and no passwords are allowed. Is there a way to connect without a password using MFA in Geoserver (preferably thorugh the sql server plugin but I’d think this would affect all databases)?
MFA is not a thing for server applications.
This is the kind of scenario where you use an app specific password, or setup something stronger in Tomcat as a JNDI Connection pool which GeoServer can then use.
You may find Migrate Tomcat applications to Tomcat on Azure App Service useful. In this use there is nothing special about GeoServer; you need to configure Tomcat DataSource following the guidelines for your operating environment. Then GeoServer is able to make use of it successfully.