Creating and Configuring the Portal Database
This topic describes how to create and configure the portal
database on Microsoft SQL Server 2005.
- Configure the SQL Server instance to use SQL
Server and Windows Authentication mode.
- Create the portal database.
- Set the portal database name to the name you specified
when you ran the Oracle WebCenter Interaction installer.
- Verify that the initial size of the portal database
is sufficient for your Oracle WebCenter Interaction deployment.
For a relatively small installation, configure a database
that is at least 100 MB. For a large enterprise with as many as 20,000
users, configure a database that is as large as 1 GB.
- Configure the portal database to use SQL
Server 2000 (80) compatibility level
- Create the portal database user.
- Create the portal database user with the user name and
password you specified when you ran the Oracle WebCenter Interaction
installer.
- Configure the portal database user to use SQL Server Authentication.
- Set the portal database user's default database to the
portal database.
- Grant the portal database user the db_owner role for the portal database.