Has anyone here gotten MODx to work successfully with MSSQL?

Hi all.

Wondering if anyone has gotten MODx 2.5.8 to work successfully on MSSQL 2017.

I managed to get the website up and running but was faced with the following issues:

1. Resource restriction is not working (ACLs)
2. Cannot unlock resources under 'manage > remove locks'
3. Logs under 'manage > reports > manager actions' not showing

All these seem to a related issue. Can anyone shed light on this?

Thank you.