SQL Requirements and install considerations
AuthAnvil is fairly lightweight on SQL. We offer the install SQL Express with our software installation as this is often all we will need. There are benefits to a full SQL server, including SQL replication and an always-on instance functionality. You may want to consider those features when deciding between SQL full or express.
The database size shouldn't be anything to worry about. The majority of the space is taken up by logging and audit data, which in most cases will be automatically managed by the AuthAnvil server software. 4 GB should be plenty.
When setting up your own SQL instance, the only key configurations are to make sure SQL Mixed Mode is enabled and to keep mind of the sa account password for SQL administrative purposes. Aside from that there are a lot of optional configurations like Microsoft monitoring, SQL replication, management studio, etc. None of these are critical features to AuthAnvil software.