Install and configure SQL Server for Groove Server Manager
Published: May 12, 2010
This article describes how to set up SQL Server to support Groove Server 2010 Manager.
In this article:
Before you begin
Identify a clean, dedicated server for this installation.
Set up SQL Server to support Groove Server Manager
Groove Server Manager stores most of its content, including user information and certificates, on a Microsoft SQL Server. This topic explains how to prepare a dedicated SQL Server for Groove Server Manager. The process involves installing, and then configuring the storage, communications, and authentication settings necessary to support Groove Server Manager. Once Groove Server Manager is operational, its IIS front end will periodically contact SQL Server to deposit content. In addition, for systems where an Active Directory forest is integrated with Groove Server Manager, the Groove Server Manager Directory Integration service will periodically contact SQL Server to synchronize the latest Active Directory forest changes with Groove Server Manager. The following procedure describes how to prepare SQL Server to support Groove Server Manager.
For more information about how to install SQL Server, see How to Install SQL Server (http://go.microsoft.com/fwlink/p/?LinkId=164997).
To set up SQL Server to support Groove Server Manager
Address the requirements in Before you begin.
Install SQL Server on a clean, dedicated Windows Server system that meets the requirements that are specified in System requirements for Groove Server 2010.
Do not install non-necessary applications on this SQL Server computer.
Groove Server Manager does not support named pipes for communications with SQL.
For a usage environment of approximately five SharePoint Workspace transactions per user per hour, configure disk storage to allow for 6 MB of storage per managed SharePoint Workspace user, including space for account backup. Adjust storage parameters as needed to support your usage environment.
Make sure that the MS-SQL port (usually 1433/TCP) is open for incoming transmissions from the Groove Server Manager.
Define a unique SQL Server host name by using the SQL Server default instance.
Configure the SQL Server authentication options for Mixed mode, to support SQL Server authentication.
As good practice, implement daily backups of Groove Server Manager databases and log files on the SQL Server computer to accommodate purges and ensure sufficient space for the Groove Manager database and transaction log.
If the computer that is running SQL Server cannot accommodate the Groove Server Manager database and transaction log, Groove Server Manager operations may stop.
U.S. English is the only supported language for the Groove Server Manager backend SQL server and the underlying operating system on which SQL Server is installed.
When you finish configuring the SQL Server storage, communications, and authentication settings, proceed to Install and configure IIS for Groove Server Manager.