+

Search Tips   |   Advanced Search


Configure WebSphere Portal to use SQL Server

View information on installing and setting up SQL Server to work with WebSphere Portal.

  1. Installing SQL Server

    View the steps to install SQL Server for use with WebSphere Portal.

  2. Modifying database properties

    This section provides information on how to modify the wkplc.properties, wkplc_comp.properties, and wkplc_dbtype.properties files to work with your database. Modify these property files before running tasks to create datbases, create users, or transfer data.

  3. 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.

  4. Optional: Assigning custom table spaces

    The repository of WebSphere Portal consists of many tables and indices that are created in default file groups. When using an existing set of file groups for the objects of the repository, specify this when executing the database transfer to the target database system.

  5. Configure WebSphere Portal to use SQL Server 2005

    This section provides information on how to manually transfer data to the SQL Server 2005 database you have installed and set up. Follow these steps to transfer WebSphere Portal, and Java Content Repository databases to SQL Server 2005. As an alternative to the manual database transfer procedure described here, you can use the configuration wizard to complete the database transfer task.


Parent topic:

Set up a remote database