While installing Symantec Endpoint Protection Manager (SEPM) to new environment, the Management Server Configuration Wizard fails to create the database and gives the following message:
"The CREATE DATABASE statement failed. The primary file must be at least [NUMBER] MB to accommodate a copy of the model database."
The model database on the SQL server is too large.
Microsoft SQL server
The model database on the server is too large, which causes the SEPM database to be smaller than the model database.
The model database is used to set the default configuration for any database being created on the server. Because our initial database is fairly small, it does not contain enough space to accommodate the initial copy of the model database.
The solution is to reduce the model database file size to the minimum of 3MB.
To reduce the size of the model database:
Once the model database size is changed, you can continue with the database creation.