Windows clustered server: Set up SQL Server manually

If you have configured the database automatically by running ConfigEngine, you do not need to run manual tasks for creating users, privileges, or table spaces, but you may decide to perform additional manual configuration for items that are not provided to you when you automatically when you run ConfigEngine.

For example, assigning custom table spaces is an optional task that is not covered by the automated ConfigEngine task.

• Windows clustered server: Create databases manually
  Use this alternative method for creating databases if you have problems running the create-database task that is documented for setting up a remote SQL Server database on Windows for a stand-alone production server.
• Windows clustered server: Create SQL Server database schemas and users
  To create database schemas and users, we can create a copy of the template SQL scripts and edit this copy to manually create the database schemas and users. The template SQL scripts should be used as a guide for creating executable scripts and contain invalid SQL syntax.
• Windows clustered server: Grant privileges to SQL Server database users
  Configuration and runtime database users are granted a different set of privileges, depending on whether these users are schema owners or not. We can create a copy of the SQL scripts and edit this copy to manually grant permissions to configuration and runtime database users.
• Windows clustered server: Assign custom SQL Server filegroups
  The repository of WebSphere Portal consists of many tables and indicecreated in default filegroups. When using an existing set of filegroups for the objects of the repository, specify this when executing the database transfer to the target management database system.

Parent: Windows clustered server: Set up SQL Server automatically or manually