Windows stand-alone: Run a task to automatically setup SQL Server databases

Before beginning, ensure that the following prerequisites are met:

• The database management system software is installed.

1. Create the databases:
   cd WP_PROFILE/ConfigEngine
   ./ConfigEngine.sh create-database -DWasPassword=foo

2. Create the database users, permissions, and table spaces:

   • ConfigEngine.bat setup-database -DWasPassword=foo

Important: After setting up the databases, enable the autogrowth feature for the log associated with the JCR database. This will ensure that uploading large files (approximately 100 MB or larger) to Web Content Manager works properly.

1. Start the Microsoft SQL Server Management Studio.

2. Expand the Databases folder.

3. Right-click on the JCR database and select Properties.

4. Click Files.

5. Locate the database log row and click the details button (...) located immediately after the Autogrowth field.

6. Check the Enable Autogrowth check box and set the autogrowth properties as needed. When using Restricted File Growth, set the value to at least 100 MB.

7. Click OK to save the changes to the Change Autogrowth screen.

8. Click OK to save the changes to the Database Properties screen.

9. Exit the Microsoft SQL Server Management Studio.

Parent: Windows stand-alone: Set up SQL Server automatically or manually