Hi Adam,
If I’m not mistaken, MS SQL is not really supported out of the box – you will need to do some manual work and write your own storage adapter as mentioned in this thread:
While that discussion was about using Postgres, I believe the same applies to MS SQL: If you need to divert from the very narrow defaults in ACE, you will have to do it yourself.