ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

Data Center Security (DCS) manager install fails with error: The CREATE DATABASE statement failed

book

Article ID: 224947

calendar_today

Updated On:

Products

Data Center Security Server Advanced

Issue/Introduction

You see an error during the database creation of a fresh DCS Manager install:

The CREATE DATABASE statement failed. The primary file must be at least x MB to accommodate a copy of the model database.

Cause

The model database template is too large

Environment

Data Center Security: Server Advanced 6.8.2 +

Resolution

Decrease the size of the model database following the steps below: 

1. Open Microsoft SQL Server Management Studio
2. Under Databases> System Databases, right-click on Model and open Properties
3. Under 'Files', change the 'Initial Size (MB)' to 1. Click OK