Before installing Group Chat, you need to create a database to store chat history and other system settings and metadata specific to Group Chat. If you are deploying a Compliance service, you can use the same database to store both chat history and compliance data, or you can create a separate database for compliance data. Use the following procedure to create the required SQL Server database. If you are creating a separate database for compliance data, repeat the procedure to create the second database.

The user account that you use to create the database becomes an owner of the database.

Important:
The database collation must be set to SQL_Latin1_General_CP1_CI_AS.

For details about creating a SQL Server database, including details about securing the database and specifying configuration options, see Creating a Database (Database Engine) at http://go.microsoft.com/fwlink/?LinkId=126923 and How to: Create a Database (SQL Server Management Studio) at http://go.microsoft.com/fwlink/?LinkId=80287 .

To create the SQL Server database

  1. Sign on to the server where you want to set up the database, using an account that has at least one of the following permissions:

    • CREATE DATABASE

    • CREATE ANY DATABASE

    • ALTER ANY DATABASE

  2. Open Microsoft SQL Server Management Studio by clicking Start, clicking All Programs, clicking Microsoft SQL Server <version>, and then clicking SQL Server Management Studio.

  3. Right-click Databases, and then click New Database.

  4. In the New Databasewizard, in Database Name, specify a unique name for the database that meets SQL Server database identifier requirements.

    Note:
    For details about SQL Server database identifier requirements, see Identifiers at http://go.microsoft.com/fwlink/?LinkId=108318 .
  5. To change the database collation, select the Optionspage, and then select SQL_Latin1_General_CP1_CI_ASfrom the collation list.

  6. To create the database by accepting all default values, click OK.