Preparing Server Platforms
Topic Last Modified: 2009-07-22
Before installing Group Chat, you need to create a database to store chat history and other system settings and metadata specific to 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 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.|
For 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/?LinkId=126923 and How to: Create a Database (SQL Server Management Studio) at http://go.microsoft.com/fwlink/?LinkId=80287.
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 ANY DATABASE
ALTER ANY DATABASE
- CREATE DATABASE
Open Microsoft 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/?LinkId=108318.
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.