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.

Dd425252.important(en-us,office.13).gifImportant:
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.

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

    Dd425252.note(en-us,office.13).gifNote:
    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 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.

Community Additions

ADD
Show: