Error Message

Error seen in the EVBAAdmin administration website:

An error occurred. Contact your administrator for help.

Event Log entries:

Log Name: Veritas Enterprise Vault
Source: Accelerator Service Processor
Event ID: 51
Level: Error
Description:
APP AS - Customer ID: 0 - Failed to create database: DATestConfiguration on SQL1. System.Data.SqlClient.SqlException (0x80131904): The CREATE DATABASE statement failed. The primary file must be at least X MB to accommodate a copy of the model database.
   at Symantec.EnterpriseVault.DatabaseAccess.EVSqlBase.Do[T](Func`1 action)
   at Symantec.EnterpriseVault.DatabaseAccess.EVSqlCommand.ExecuteNonQuery()
   at KVS.Accelerator.Application.Install.CreatePhysicalConfigurationDatabase(String DSNMasterDB, String SQLServer, String SQLDatabase, InstallArgumentDS ArgsDS)
ClientConnectionId:9a121e77-3541-4967-a3fe-86081edc555e
Error Number:1803,State:1,Class:16

Log Name: Veritas Enterprise Vault
Source: Accelerator Service Processor
Event ID: 61
Level: Error
Description:
APP AS - Customer ID: 0 - Initialization failed. System.Data.SqlClient.SqlException (0x80131904): The CREATE DATABASE statement failed. The primary file must be at least X MB to accommodate a copy of the model database.
   at Symantec.EnterpriseVault.DatabaseAccess.EVSqlBase.Do[T](Func`1 action)
   at Symantec.EnterpriseVault.DatabaseAccess.EVSqlCommand.ExecuteNonQuery()
   at KVS.Accelerator.Application.Install.CreatePhysicalConfigurationDatabase(String DSNMasterDB, String SQLServer, String SQLDatabase, InstallArgumentDS ArgsDS)
   at KVS.Accelerator.Application.Install.InstallConfigurationDB(String ConfigDSN, String DSNMasterDB, InstallArgumentDS ArgsDS)
ClientConnectionId:9a121e77-3541-4967-a3fe-86081edc555e
Error Number:1803,State:1,Class:16

The Model database is a SQL System database that is used as the template for creating a new database. This issue is caused by the Model database on the SQL server being larger than the default initial size of the database being created. For a Configuration database, the default initial size is 10 MB; for a Customer database, the default initial size is 300 MB.

Note: In SQL 2014 and earlier, the Model database's initial file size was set to 3 MB with a 10% autogrowth. From SQL 2016, the Model database has an initial size of 8 MB with a 64 MB autogrowth. See article https://blogs.msdn.microsoft.com/sql_server_team/new-defaults-for-model-and-user-databases-in-sql-server-2016/ for more information.

The database creation window in the EVBAAdmin administration website allows for the database's initial size to be edited under the Initial Database Size setting. Simply edit this setting to a value that is equal to or higher than the Model database's .mdf file size. This file size should be listed in the Event Log entries in the line 'The primary file must be at least X MB to accommodate a copy of the model database' as above and can be confirmed in the SQL Server Management Studio (SSMS) under Database | System Databases | Right-click on Model | Properties | Files | Logical Name: modeldev | Initial Size (MB).