Symptoms

You run the installer for SpiraTest, SpiraTeam, SpiraPlan or KronoDesk and you receive the following error (or something similar):

The CREATE DATABASE statement failed. The primary file must be at least 1024 MB to accommodate a copy of the model database. [System.Data.SqlClient.SqlException]

This is caused by the initial database specified by the installer being smaller than the SQL Server model database. By default, Spira/KronoDesk have a 50MB initial size specified in the database creation scripts.

Solution

To solve the problem, you can set a Windows system environment variable that overrides the default initial database size:

set TST_DB_SIZE=1024

You can also set this value in the Windows control panel as well.