Preparing Server Platforms

Communications Server 2007 R2

Topic Last Modified: 2009-07-22

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.

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 and How to: Create a Database (SQL Server Management Studio) at

  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:

  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 Database wizard, in Database Name, specify a unique name for the database that meets SQL Server database identifier requirements.

    For details about SQL Server database identifier requirements, see Identifiers at
  5. To change the database collation, select the Options page, and then select SQL_Latin1_General_CP1_CI_AS from the collation list.

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