New SEPM installation gives error message "The CREATE DATABASE statement failed. . . "

Products

• Endpoint Protection

Issue/Introduction

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."

Environment

Microsoft SQL server

Cause

The model database on the SQL server is too large. 

Resolution

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: 

1. In Microsoft SQL Server Management Studio, expand Databases > System Databases.
2. Right click Model and then click Properties.
3. In the Database Properties - model window, in the left pane, click Files.
4. In the right pane, in the Initial Size field for the model database file, set the value to 3. 
5. Click OK.

Once the model database size is changed, you can continue with the database creation.