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.|
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 ANY DATABASE
ALTER ANY DATABASE
- CREATE DATABASE
Open SQL Server Management Studio by clicking Start, clicking All Programs, clicking Microsoft SQL Server <version>, and then clicking SQL Server Management Studio.
Right-click Databases, and then click New Database.
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.
To change the database collation, select the Options page, and then select SQL_Latin1_General_CP1_CI_AS from the collation list.
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.