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.


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:




  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.


    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.

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