Due on Web Application that uses SQM table for authentication

We have a web application from Tyler Technologies that uses IIS as it’s underlying web server. However for the authentication it validates against a MS SQL server table within the application’s DB. Can Duo be used for adding 2nd factor in such setup?

Anyone tried setting up Duo with IIS but the authentication is not done by AD/LDAP?