Good question. MongoDB is a NoSQL database. So only choose it if that is what you need.

If you need SQL ability, MySQL is good. It as well as PostreSQL, which I prefer, both have a JSON data type. This allows you to have SQL ans NoSQL in one database.

SQL Server is SQL only.