Manually Installing the Job Submission Sample

  • Article

Although you can install the Excel Services and Excel 2007 Windows Compute Cluster Server (CCS) 2003 Job Submission sample by using the Setup.exe file supplied with the sample download, and uninstall it through Add or Remove Programs in Control Panel, you might want to install and uninstall it manually. This topic describes how to install and uninstall the sample manually.

Manually Installing the Head Node Software

The process for manually installing the head node software has three steps:

  1. Create the virtual directory.

  2. Install the Web Parts within Microsoft Office SharePoint Server 2007.

  3. Create the head node shares.

Creating the Virtual Directory

To create the virtual directory

  1. Start Internet Information Services (IIS) Manager.

  2. Under the SharePoint - 80 Web site node, create a virtual directory in the _layouts node using the following path:

    C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\12\template\layouts\ECS\

  3. From the sample download, copy the contents of the Web project in the ECSIntegration solution and the file [Visual Studio Project Folder] \HeadNodesetup\CCSStatusWebPart.CAB to the following path:

    C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\12\template\layouts\ECS\

  4. Use the ModifyASPXSs.vbs script to modify the .aspx pages to work properly within the SharePoint environment. The ModifyASPXSs.vbs script requires a single parameter: the installation directory of the Web application.

    Following is an example of the CScript command. From a Command Prompt window, run the following.

    cscript.exe ModifyASPXs.vbs "C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\12\template\layouts\ECS\"

Installing Web Parts on Office SharePoint Server 2007

The installation of Web Parts on Office SharePoint Server 2007 occurs in three steps:

  1. The Web Part pack is added to the SharePoint page.

  2. The Web Part is installed as a Feature in Office SharePoint Server 2007.

  3. The context menu is installed as a Feature in Office SharePoint Server 2007.

You can execute the Stsadm.exe file through a command prompt to perform all three steps. The Stsadm.exe file is located in the following path:

C:\Program Files (x86)\Common Files\Microsoft Shared\Web Server Extensions\12\BIN\

The files used as arguments are located in the Web application installation directory discussed previously (C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\12\template\layouts\ECS\).

Following are examples of how to execute the three steps in a Command Prompt window. Replace [HeadNode Name] with the name of the head node, and then run the following.

"C:\Program Files (x86)\Common Files\Microsoft Shared\Web Server Extensions\12\BIN\STSADM.exe" -o addwppack -filename " C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\12\template\layouts\ECS\CCSStatusWebPart.cab"" -globalinstall -url http://[HeadNode Name] –force

"C:\Program Files (x86)\Common Files\Microsoft Shared\Web Server Extensions\12\BIN\STSADM.exe" -o installfeature -filename "CCSContextMenu\Feature.xml" -force

"C:\Program Files (x86)\Common Files\Microsoft Shared\Web Server Extensions\12\BIN\STSADM.exe" -o installfeature -filename "CCSStatusWebPart\Feature.xml" -force

Creating the Head Node Shares

You must create two UNC file shares in the following locations:

  • On the head node that is visible to the client computers. The UNC file share is the location in which the XML configuration job files (for example, Workbook Task XML file, Workbook Job XML file, CCS Job XML file) are placed by the Job Submission task pane add-in. These XML configuration job files are used by the compute cluster to perform Excel workbook calculations.

  • On the head node that is visible to the compute nodes. The compute nodes place XML result files in this UNC file share when they complete their calculations. Later processes collect these results and make them available to the client.

You can create the file shares by using the CreateHeadNodeShare.vbs script located in the HeadNodeSetup directory. Following are the values passed to the script:

  • HeadNodeFolder, which is a local path to the head node share location on the head node. Following is the typical path:

    C:\Program Files (x86)\Microsoft ECS HeadNode\HeadNodeShare\

  • SourceFolder, which is a local path to the source share location on the head node. Following is the typical path:

    C:\Program Files (x86)\Microsoft ECS HeadNode\SourceShare\

  • Target directory for the Web application. Following is the typical path:

    C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\12\template\layouts\ECS\

  • ComputeNode folder, which is the installation location of the compute node on the head node. Following is the typical path:

    C:\Program Files (x86)\Microsoft ECS ComputeNode\

The following example uses the CScript command to create the head node shares. Run the following command in a Command Prompt window.

cscript.exe CreateHeadNodeShare.vbs "C:\Program Files (x86)\Microsoft ECS HeadNode\HeadNodeShare\" "C:\Program Files (x86)\Microsoft ECS HeadNode\SourceShare\" "C:\Program Files (x86)\Microsoft ECS ComputeNode\" "C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\12\template\layouts\ECS\"

Installing the Compute Node Software

When using Setup.exe, the compute node software installation is performed as part of the head node installation on the head node.

To manually install the software on the compute nodes, copy the following files to the installation folder that is requested during the installation process (typically, the path is C:\Program Files (x86)\Microsoft ECS ComputeNode\):

  • CCPAPI.dll

  • ExecutionEngine.exe

  • ResultEngine.exe

  • SetCredCache.exe

Installing the Job Submission Task Pane Add-in

To install the Job Submission task pane add-in manually

  1. Copy the following files to the installation folder requested during the installation process (typically, the path is C:\Program Files (x86)\ Compute Cluster Excel Addin\):

    • InstallActiveX.vbs

    • UninstallActiveX.vbs

    • SetSecurity.dll

    • ExcelComputeClusterAddin.dll

    • ExcelComputeClusterAddin.tlb

    • Microsoft.Office.Tools.Common.dll

    • Microsoft.Office.Tools.Common2007.dll

    • Microsoft.Office.Tools.Excel.dll

    • Microsoft.VisualStudio.Tools.Applications.Runtime.dll

    • Microsoft.VisualStudio.Tools.Application.Runtime.tlb

  2. Run the InstallActiveX.vbs script to register the assembly and create a custom security code group so that the assembly is fully trusted on the computer on which it is installed. The only parameter required by this script is the target installation directory for the add-in.

    Following is a CScript command line example. Run the following in a Command Prompt window.

    cscript.exe InstallActiveX.vbs "C:\Program Files (x86)\ Compute Cluster Excel Addin\"

  3. Use the SetSecurityCmd.exe program to add and remove the security code group to establish the add-in as a full trust assembly.

    Following is an example of how to use the SetSecurityCmd.exe command. Run the following in a Command Prompt window.

    SetSecurityCmd.exe /allUsers="1" /solutionCodeGroupName="ExcelTaskPane" /solutionCodeGroupDescription="ExcelTaskPaneAddIn" /targetDir="C:\Program Files (x86)\microsoft\Compute Cluster Excel Addin" /assemblyName="ExcelComputeClusterAddin.dll" /assemblyCodeGroupName="ExcelTaskPaneDLL" /assemblyCodeGroupDescription="Assembly code group to establish the assembly as full trust."

    You can use the /u switch to uninstall the code group from the computer.

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

  1. On the Site Actions menu, select Site Settings and click Modify All Site Settings.

  2. On the Site Settings page, select Site features under Site Administration.

  3. On the Site Features page, click Activate to activate the CCS Context Menu and CCS Status Web Part features.

Uninstalling the Head Node Software

Uninstalling the head node software is a two-step process:

  1. Uninstall the Web Parts from Office SharePoint Server 2007.

  2. Remove the directories.

Uninstalling Web Parts from Office SharePoint Server 2007

SharepointUninstall.vbs is the only scripted portion of the uninstall process. The script to uninstall the Web Parts uses only one parameter; the location of the installation directory of the Web application.

Following is sample CScript command to uninstall the Web Parts.

To uninstall the Web Parts from Office SharePoint Server

  • Run the following in a Command Prompt window.

    cscript.exe sharepointuninstal.vbs "C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\12\template\layouts\ECS\"

The only remaining step in the head node uninstall process is to remove the directories created as part of the installation.

To remove the directories created during installation

  1. Go to the default directory locations used for the installation. For more information, see Creating the Head Node Share.

  2. Remove directories.

Uninstalling the Compute Node Software

To manually uninstall the software on the compute nodes

  • Remove the compute cluster installation directory. Following is the default directory path.

    C:\Program Files (x86)\Microsoft ECS ComputeNode\

Uninstalling the Job Submission Task Pane Add-in

To uninstall the Job Submission task pane add-in manually

  • To uninstall and remove the installation directory, run both the UninstallActiveX.vbs script and SetSecurityCmd.exe program.

    1. To uninstall the Job Submission add-in by using UninstallActiveX.vbs, run script like the following example in a Command Prompt window.

      cscript.exe UninstallActiveX.vbs "C:\Program Files (x86)\ Compute Cluster Excel Addin\"

    2. To remove a code group by using SetSecurityCmd script, run script like the following from a Command Prompt window.

      SetSecurityCmd.exe /allUsers="1" /solutionCodeGroupName="ExcelTaskPane" /solutionCodeGroupDescription="ExcelTaskPaneAddIn" /targetDir="C:\Program Files (x86)\microsoft\Compute Cluster Excel Addin" /assemblyName="ExcelComputeClusterAddin.dll" /assemblyCodeGroupName="ExcelTaskPaneDLL" /assemblyCodeGroupDescription="Assembly code group to establish the assembly as full trust." /u

See Also

Concepts

Performing a Parametric Sweep using the Job Submission Sample
Job Submission Task Pane Add-in
Walkthrough: Creating a Parametric Sweep Workbook for the Job Submission Task Pane
Overview of Excel Calculation Services on Compute Cluster Server API
Dependent Technology Overview for the Job Submission Sample
Installing a Compute Cluster for the Job Submission Sample
Additional Resources