Error while creating WEM database: "Database creation error!"
Article ID: CTX228982
Updated On:
Description
Database Creation Wizard produces the following error while creating a new WEM database: "Database creation error!".
The Citrix WEM Database Management Utility Debug log file located in "C:\Program Files (x86)\Norskale\Norskale Infrastructure Services" reports the following error when attempting to create the database:
Exception -> CreateVuemdb.Run(): SqlDatabaseHelper..() connection Error: 1803| CREATE DATABASE statement failed. The primary file must be at least 100 MB to accommodate a copy of the model database.
Resolution
1. Open Microsoft SQL Server Management Studio.
2. Under Databases > System Databases, right-click on the Model database and open Properties.
3. Go to the 'Files' page and change the 'Initial Size (MB)' field to 3 for the PRIMARY database file.
4. Click OK.
2. Under Databases > System Databases, right-click on the Model database and open Properties.
3. Go to the 'Files' page and change the 'Initial Size (MB)' field to 3 for the PRIMARY database file.
4. Click OK.
Problem Cause
The Model database on SQL Server Management Studio was configured with an Initial Size of 100 MB for the PRIMARY file and not with the default value of 3 MB.Additional Information
https://support.symantec.com/en_US/article.TECH226883.html
http://redbrickdata.com/sql-server-best-practices-using-the-model-database/
http://redbrickdata.com/sql-server-best-practices-using-the-model-database/
Was this article helpful?
Yes
No
Powered by
