Installing Spira or KronoDesk with a large SQL Server model

Installing Spira or KronoDesk with a large SQL Server model database size

When you are installing SpiraTest, SpiraTeam, SpiraPlan or KronoDesk on a database server with a large 'model' database sometimes the install will fail because the initial Spira/KronoDesk database is not large enough to contain your model database. This article provides the solution

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.

Spira Helps You Deliver Quality Software, Faster and With Lower Risk

And if you have any questions, please email or call us at +1 (202) 558-6885

Installing Spira or KronoDesk with a large SQL Server model database size

Symptoms

Solution

Spira Helps You Deliver Quality Software, Faster and With Lower Risk

Search Results