Add query servers to a farm (Office SharePoint Server 2007)

  • Article

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: 2009-05-29

This article explains how to add query servers to a Microsoft Office SharePoint Server 2007 deployment. To add a query server, you must complete the following tasks:

  • Task 1: Add an application server to the farm

  • Task 2: Configure application server roles

The following sections explain how to complete these tasks. You can repeat Task 1 and the query server configuration in Task 2 at any time to add more query servers as appropriate for the organization.

Important

Before you can add a query server, you must install and configure Office SharePoint Server 2007 on the first computer in the deployment by following the instructions under “Run Setup on the first server” in Install Office SharePoint Server 2007 and run the SharePoint Products and Technologies configuration wizard. After you complete that procedure, you can add query servers to the deployment at any time. For information about Office SharePoint Server 2007 planning, server roles, and topology options, see Planning and architecture for Office SharePoint Server 2007.

Task 1: Add an application server to the farm

This section explains how to add an application server after you install Office SharePoint Server 2007 on the first computer in a deployment. Follow these steps when you install the product on another computer:

Important

To perform the following procedures, you must be a farm administrator.

  • Step 1: Prepare hardware and software

  • Step 2: Start the installation

  • Step 3: Run the SharePoint Products and Technologies configuration wizard

You can repeat these steps to add more application servers to the farm.

Note

This article describes all of the steps that you must take to complete Task 1. This includes many of the same actions that are described in Install Office SharePoint Server 2007 and run the SharePoint Products and Technologies configuration wizard.

Step 1: Prepare hardware and software

Before you start a new installation, ensure that the computer that you want to add to the existing deployment meets the minimum requirements described in Determine hardware and software requirements (Office SharePoint Server).

Step 2: Start the installation

Use this procedure to begin the setup process on the computer that you want to add to the existing deployment.

To start the installation

  • From the product disc, run Setup.exe.

  • On the Enter your Product Key page, enter the product key, and then click Continue.

    Note

    Setup automatically verifies the product key, places a green check mark next to the text box, and enables the Continue button after it validates the key. If the key is not valid, Setup displays a red circle next to the text box and prompts you that the key is incorrect.

  • On the Read the Microsoft Software License Terms page, review the terms, select the I accept the terms of this agreement check box, and then click Continue.

  • On the Choose the installation that you want page, click Advanced.

  • On the Server Type tab, click Complete.

  • Optionally, to install Office SharePoint Server 2007 at a custom location, select the File Location tab, and then type the location or Browse to the location.

  • Optionally, to participate in the Customer Experience Improvement Program, select the Feedback tab and select the option that you want. To learn more about the program, click the link. You must have an Internet connection to view the program information.

  • When you have selected the correct options, click Install Now.

  • When Setup finishes, a dialog box appears that prompts you to complete the configuration of the server. Be sure that the Run the SharePoint Products and Technologies Configuration Wizard now check box is selected.

  • Click Close to start the configuration wizard. Instructions for completing the wizard are provided in the next set of steps.

Step 3: Run the SharePoint Products and Technologies configuration wizard

After Setup finishes, you can use the SharePoint Products and Technologies configuration wizard to configure Office SharePoint Server 2007. The configuration wizard automates several configuration tasks. This includes installing Office SharePoint Server 2007 services. Use the following instructions to run the SharePoint Products and Technologies configuration wizard.

To run the SharePoint Products and Technologies configuration wizard

  1. On the Welcome to SharePoint Products and Technologies page, click Next.

  2. In the dialog box that notifies you that some services might have to be restarted during configuration, click Yes.

  3. On the Connect to a server farm page, click Yes, I want to connect to an existing server farm, and then click Next.

  4. In the Specify Configuration Database Settings dialog box, in the Database server box, type the name of the computer that is running SQL Server.

  5. Click Retrieve Database Names, and then from the Database name list, select the database name that you created when you configured the first server in the server farm.

  6. In the User name box, type the user name of the account that is used to connect to the computer that is running SQL Server. (Be sure to type the user name in the format DOMAIN\username.) This must be the same user account that you used when you configured the first server.

  7. In the Password box, type the user's password, and then click Next.

  8. On the Completing the SharePoint Products and Technologies Configuration Wizard page, click Next.

  9. On the Configuration Successful page, click Finish.

Task 2: Configure application server roles

You must now configure the application servers in the farm by doing the following:

  • Step 1: Configure the index server

  • Step 2: Configure query servers

Important

To perform the following procedures, you must be a Farm administrator.

Important

Task 2 applies only to a farm that has more than one application server.

Step 1: Configure the index server

The instructions under “Run Setup on the first server” in Install Office SharePoint Server 2007 and run the SharePoint Products and Technologies configuration wizard explain how to deploy the first computer in a farm so that it is configured to have the application server role and the Web server role. As the sole application server for the deployment, that computer is automatically configured as the index server and query server. When you add a query server to a farm, we recommend that you continue to use the first server in the deployment as the index server and not as a query server. To do so, you must disable the query server role on that first farm server as explained in the following procedure. Typically you have to perform this procedure only one time for any farm that has multiple application servers.

To configure the index server

  1. From the Central Administration Web site, click Operations.

  2. On the Operations page, under Topology and Services, click Services on server.

  3. On the Services on Server page, under Complete all steps below, click the first computer that you deployed for this farm. If the first computer that you deployed for the farm does not appear:

    1. Click the server name that currently appears.

    2. Click Change Server.

    3. In the Select Server dialog box, click the first computer that you deployed for this farm.

  4. In the Start services in the table below section, in the Status column for Office SharePoint Server Search, if the status is Stopped, in the Action column click Start.

  5. In the Service column, click Office SharePoint Server Search.

  6. On the Configure Office SharePoint Server Search Service Settings page, in the Query and Indexing section:

    1. Ensure that the Use this server for indexing content check box is selected.

    2. Clear the Use this server for serving search queries check box.

  7. Click OK.

Configuration of the index server is now completed.

Important

You must now configure the other application servers as query servers, as explained in the following section.

Step 2: Configure query servers

Use this procedure to configure each of the other application servers as query servers. On each of these servers, you enable the query server role and ensure that the index server role is disabled.

To configure a query server

  1. From the Central Administration Web site, click Operations.

  2. On the Operations page, under Topology and Services, click Services on server.

  3. On the Services on Server page, under Complete all steps below, click the first computer that you deployed for this farm. If the first computer that you deployed for the farm does not appear:

    1. Click the server name that currently appears.

    2. Click Change Server.

    3. In the Select Server dialog box, click the first computer that you deployed for this farm.

  4. In the Start services in the table below section, in the Status column for Office SharePoint Server Search, if the status is Stopped, in the Action column click Start.

  5. In the Service column, click Office SharePoint Server Search.

  6. On the Configure Office SharePoint Server Search Service Settings page, in the Query and Indexing section:

    1. Clear the Use this server for indexing content check box.

    2. Select the Use this server for serving search queries check box.

  7. Click Start. The configuration of the application server as a query server is now completed.

See Also

Concepts

Planning and architecture for Office SharePoint Server 2007
Install Office SharePoint Server 2007 in a server farm environment