Installing a Compute Cluster for the Job Submission Sample

Article
10/16/2013

This topic gives detailed instructions about how to install and deploy a Windows Compute Cluster Server (CCS) 2003 for use with Excel Services and Excel 2007 Windows Compute Cluster Server 2003 Job Submission sample.

Order of Installation of Supporting Software

To prepare the Windows Server 2003 compute cluster for use with the Job Submission task pane add-in, you must install the prerequisite software in a particular order. The order is outlined in the following steps.

To install prerequisites

Install Microsoft SQL Server 2005 on a separate dedicated computer.

Note

For details about how to deploy SQL Server 2005, see SQL Server 2005 Deployment.
On the head node and compute nodes, perform the following:
1. Click Start, point to Administrative Tools, and then click Configure Your Server Wizard.
2. In the Configure Your Server Wizard dialog box, click Application server as the server role for the computer, as shown in Figure 1.
  
  Figure 1. Selecting Application server as the server role
3. Install all Microsoft Office SharePoint Server 2007 prerequisites, as described in Install all prerequisites.
  
  These prerequisites include: Microsoft .NET Framework 3.0 and enable ASP.NET 2.0, Windows Workflow Foundation (WF)

To install and configure Office SharePoint Server 2007 on the head node and compute nodes in the compute cluster

In the Microsoft Office SharePoint Server 2007 dialog box, click Advanced installation, and then click Complete to include the front-end Web server and application server, as shown in Figures 2 and 3.

Note

For more information about how to install Office SharePoint 2007 in a server environment, see Install Office SharePoint Server 2007 in a server farm environment.

Figure 2. Selecting Advanced installation type

Figure 3. Selecting Complete installation type
Create a Shared Services Provider (SSP) and start Excel Services on each computer as follows:

Note

For more information about how to create and configure SSPs, see Chapter overview: Create and configure Shared Services Providers.
1. To start SharePoint Central Administration. click Start, point to Microsoft Office Server, and then click SharePoint 3.0 Central Administration.
2. On the Central Administration page, click the Operation tab. Under Topology and Services, click the Services on Server link, as shown in Figure 4.
  
  Figure 4. Services on server link
3. To start Office SharePoint Server Search, select the box to indicate the server is used for indexing content, as shown in Figure 5. This step creates an SSP.
  
  Figure 5. Starting Office SharePoint Server Search
4. On the SharePoint Central Administration page, click the Application Management tab. Create an SSP by using the Create or configure this farm's shared services link, as shown in Figure 6.
  
  Figure 6. Creating an SSP
5. To start Excel Services on all computers, on the Operations tab, click the Services on Server link.
Add a trusted file location. In Office SharePoint Server 2007, a trusted file location can be a SharePoint document library, a UNC path, or an HTTP Web site that is configured as a trusted repository for workbooks that Excel Calculation Services can access. Excel Calculation Services opens only workbooks that are stored in trusted file locations.
1. On the Central Administration page, click Application Management.
2. On the Application Management page, under Office SharePoint Server Shared Services, click Create or configure this farm's shared services (see Figure 6).
3. On the Manage this Farm's Shared Services page, click SharedServices1 (Default), as shown in Figure 7. This is the SSP that you configure.
  
  Figure 7. Configuring the default shared services
4. On the Shared Services Administration: ShareServices1 page, under Excel Services Settings, click Trusted file locations, as shown in Figure 8.
  
  Figure 8. Selecting the Trusted file locations link
5. On the Excel Services Trusted File Locations page, click Add Trusted File Location,****as shown in Figure 9.
  
  Figure 9. Clicking Add Trusted File Location link
6. Under Address, type the location and name of the SharePoint document library to add as a trusted file location in Excel Services, as shown in Figure 10.
  
  For Location Type, click Windows SharePoint Services.
  
  In Trust Children, click Children trusted.
  
  Figure 10. Selecting options in the Address section
7. In the External Data row, under Allow External Data, click Trusted data connection libraries and embedded.
  
  Figure 11. Selecting Trusted data connection libraries and embedded
8. In the User-Defined Functions row, under Allow User-Defined Functions, click User-defined functions allowed, and then click OK.
  
  Figure 12. Selecting user-defined functions allowed
  
  Note
  
  For more information about adding a trusted file location, see Add a trusted file location.
Set the Excel Services load-balancing scheme to Local.
1. On the Central Administration page, click Application Management.
2. On the Application Management page, under Office SharePoint Server Shared Services, click Create or configure this farm's shared services (see Figure 6).
3. On the Manage this Farm's Shared Services page, click SharedServices1 (or if you used a different SSP name in the earlier steps, click that name).
4. On the Shared Services Administration page, under Excel Services Settings, click Edit Excel Services settings.
5. On the Excel Services Settings page, under Load Balancing Scheme, click Local.
6. Click OK.

Note

For more information about Office SharePoint Server 2007 deployment and configuration, see Deploy in a simple server farm (Office SharePoint Server) and Chapter overview: Additional configuration tasks.

To install Windows Compute Cluster Server 2003

Create a SQL instance called COMPUTECLUSTER.
Install Windows CCS 2003 on the head node and compute nodes. For information about how to install Windows CCS 2003, see Windows Compute Cluster Server 2003 Deployment.

To install the Excel Services and Excel 2007 Submission task pane add-in

Install Microsoft Office Excel 2007 on a client computer.

Note

For more information about how to install Excel 2007, see Install or remove individual Office programs and components.
Install the Job Submission task pane add-in on the client computer.

Note

For more information about how to install the Job Submission task pane add-in, see Manually Installing the Job Submission Sample.

After you have completed these steps, the Excel Services and Excel 2007 CCS Job Submission sample is ready to use. You can perform a test of the system by following the steps in Walkthrough: Creating a Parametric Sweep Workbook for the Job Submission Task Pane.

Activating the Custom Web Form

Before you can use the custom Web form, you must first activate it. The steps to activate the custom Web form are outlined in the following steps.

To activate the custom Web form

On the Site Actions menu, select Site Settings and click Modify All Site Settings.
On the Site Settings page, select Site features under Site Administration.
On the Site Features page, click Activate to activate the CCS Context Menu and CCS Status Web Part features.