Prepare the database servers

Applies To: Office SharePoint Server 2007

This Office product will reach end of support on October 10, 2017. To stay supported, you will need to upgrade. For more information, see , Resources to help you upgrade your Office 2007 servers and clients.


Topic Last Modified: 2016-11-14

In this article:

  • SQL Server and database collation

  • Required accounts

  • Preinstall databases (optional)

Before installing Microsoft Office SharePoint Server 2007, you must prepare the database server.

The database server must be running Microsoft SQL Server 2005 or Microsoft SQL Server 2000 with the most recent service pack.

The Office SharePoint Server 2007 Setup program automatically creates the necessary databases when you install and configure Office SharePoint Server 2007. Optionally, you can preinstall the required databases if your IT environment or policies require this.

For more information about prerequisites, see Determine hardware and software requirements (Office SharePoint Server).

If you are using SQL Server 2005, you must also change the surface area settings.

Configure surface area settings in SQL Server 2005

  1. Click Start, point to All Programs, point to Microsoft SQL Server 2005, point to Configuration Tools, and then click SQL Server Surface Area Configuration.

  2. In the SQL Server 2005 Surface Area Configuration dialog box, click Surface Area Configuration for Services and Connections.

  3. In the tree view, expand the node for your instance of SQL Server, expand the Database Engine node, and then click Remote Connections.

  4. Select Local and Remote Connections, select Using both TCP/IP and named pipes, and then click OK.

SQL Server and database collation

The SQL Server collation must be configured for case-insensitive. The SQL Server database collation must be configured for case-insensitive, accent-sensitive, Kana-sensitive, and width-sensitive. This is to ensure file name uniqueness consistent with the Windows operating system. For more information about collations, see "Selecting a SQL Collation" or "Collation Settings in Setup" in SQL Server Books Online.

Required accounts

The following table describes the accounts that are used to configure Microsoft SQL Server and to install Office SharePoint Server 2007. For more information about the required accounts, including specific privileges required for these accounts, see Plan for administrative and service accounts (Office SharePoint Server).

Account Purpose

SQL Server service account

SQL Server prompts for this account during SQL Server Setup. This account is used as the service account for the following SQL Server services:



If you are not using the default instance, these services will be shown as:

  • MSSQL$InstanceName

  • SQLAgent$InstanceName

Setup user account

The user account that is used to run Setup on each server.

Server farm account

This account is also referred to as:

  • Database access account

This account is:

  • The application pool account for the Central Administration site

  • The process account for the Windows SharePoint Services Timer (SPAdmin) service

Preinstall databases (optional)

In many IT environments, database creation and management are handled by the database administrator (DBA). Security and other policies might require that the DBA create the databases required by Office SharePoint Server 2007. This topic provides details about how the DBA can create these databases before beginning the Office SharePoint Server 2007 installation or creation of a Shared Services Provider (SSP). For more information about preinstalling databases, including detailed procedures, see Deploy using DBA-created databases (Office SharePoint Server).

Download this book

This topic is included in the following downloadable book for easier reading and printing:

See the full list of available books at Office SharePoint Server technical library.