Creating a Database for Group Chat Server

 

Topic Last Modified: 2012-10-14

Before installing Microsoft Lync Server 2010, Group Chat, you need to create a database to store chat history and other system settings and metadata specific to Lync Server 2010, 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 Microsoft 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.

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 administrator rights and permissions:

    • CREATE DATABASE

    • CREATE ANY DATABASE

    • ALTER ANY DATABASE

  2. Open 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.

    Note

    For details about SQL Server database identifier requirements, see Identifiers at http://go.microsoft.com/fwlink/p/?LinkId=204129.

  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.

    For additional 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/p/?LinkId=126923 and How to: Create a Database (SQL Server Management Studio) at http://go.microsoft.com/fwlink/p/?LinkId=204121.