Export (0) Print
Expand All

Creating a Database for Group Chat Server

Lync Server 2010
 

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.

importantImportant:
The database collation must be set to SQL_Latin1_General_CP1_CI_AS.

  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.

    noteNote:
    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.

 
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft