ms sql 2016 should work fine
with ldap auth a "SiteUser" will be created automatically in the database the first time the user authenticates.
there is no access to ldap/AD roles or groups, mojoportal uses its own roles internally, so once SiteUsers are created you would have to add those users to roles within mojoportal to control their access
see also the documentation