Through Project, Settings you can configure your local database systems, including MSSQL.
I was able to figured it out by installing my own SQL server locally, and then using the following 2 documentations to connect to a database instance on my server:
I thought that this was possible with just Mendix, but you can only connect to an existing one, not instantiate one.