Preparing Server Platforms (2007 R2 Beta)

  • Article

[This is preliminary documentation and is subject to change. Blank topics are included as placeholders.]

After you install SQL Server, you need to create a database to store chat history. If you are deploying a Compliance Server, 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 used to create the database becomes an owner of the database.

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 2005, and then clicking SQL Server Management Studio.

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

  4. In New Database, in Database Name, specify a unique name for the database that meets SQL Server database identifier requirements. For information about these requirements, see Identifiers.

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

For information about creating a SQL Server database, including details about securing the database and specifying configuration options, see the following: