Set up databases

This topic provides instructions on automatically setting up your database using...

ConfigEngine

As an alternative to automatically setting up the database, you can manually create users and grant privileges. Before you begin, ensure that the following prerequisites are met:

• Supported database software is installed.

• Property files are modified.

• Database user names and passwords should not contain spaces and should comply with both the database management system software requirements and WebSphere Portal requirements for administering users and groups.

Prerequisites

Installing SQL Server

Modifying database properties

1. cd profile_root/ConfigEngine

2. To create the databases, type the following command:

   • ConfigEngine.bat create-database -DWasPassword=password

3. To create the database users, type the following command:

   • ConfigEngine.bat setup-database -DWasPassword=password

   This task will automatically create the necessary users permissions, and table spaces.

Parent topic:

Configure WebSphere Portal to use SQL Server

Previous topic:

Modifying database properties

Next topic:

Assigning custom table spaces

Related tasks

Create users and databases for SQL Server on Windows

---