Solaris stand-alone: 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.

• Solaris stand-alone: Create databases manually
  This section provides information on setting up SQL Server for WebSphere Portal.
• Solaris stand-alone: Create 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.
• Solaris stand-alone: 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.
• Solaris stand-alone: 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: Solaris stand-alone: Set up SQL Server automatically or manually