Prepare the database servers
Updated: March 26, 2009
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:
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
Click Start, point to All Programs, point to Microsoft SQL Server 2005, point to Configuration Tools, and then click SQL Server Surface Area Configuration.
In the SQL Server 2005 Surface Area Configuration dialog box, click Surface Area Configuration for Services and Connections.
In the tree view, expand the node for your instance of SQL Server, expand the Database Engine node, and then click Remote Connections.
Select Local and Remote Connections, select Using both TCP/IP and named pipes, and then click OK.
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.
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).
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:
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:
This account is:
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).