> AquaLogic Interaction Installation Guide for Windows > Installation > Creating and Configuring a Microsoft SQL Server Database > Creating and Configuring the Portal Database

AquaLogic Interaction Installation Guide for Windows

     Previous Next  Open TOC in new window   View as PDF - New Window  Get Adobe Reader - New Window
Content starts here

Creating and Configuring the Portal Database

This topic describes how to create and configure the portal database on Microsoft SQL Server 2005.

  1. Configure the SQL Server instance to use SQL Server and Windows Authentication mode.
  2. Create the portal database.
    1. Set the portal database name to the name you specified when you ran the AquaLogic Interaction installer.
    2. Verify that the initial size of the Portal database is sufficient for your AquaLogic 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.

    3. Configure the Portal database to use SQL Server 2000 (80) compatibility level
  3. Create the portal database user.
    1. Create the Portal database user with the user name and password you specified when you ran the AquaLogic Interaction installer.
    2. Configure the Portal database user to use SQL Server Authentication.
    3. Set the Portal database user's default database to the Portal database.
    4. Set the Portal database user's default database to the Portal database.
    5. Grant the Portal database user the sysadmin server role.
Parent topic: Creating and Configuring a Microsoft SQL Server Database

  Back to Top      Previous Next