The IBM Pattern lab uses an asset-based approach to create reusable and customizable components that collectively make an automation package for a given software product and solution deployment.
Step 1: Introducing the Microsoft SQL Server v2008 R2 SP2 script package capabilities
This script package installs Microsoft SQL server version 2008, release 2 with Service Pack 2.
The underlying operating system part, which this script package has been tested on, is Windows Server 2008 R2, 64-bit.
This deployment mechanism for the Microsoft SQL server product supports the following topology: basic installation, single host. It covers the installation of the following product components:
- SQL Engine and related components
- Analysis Service and related components
- Reporting Service and related components
- Integration Service and related components
Step 2: Identifying the script package parameters
All the parameters found in Table 1 and Table 2 will be exposed through the script package parameters in the IBM Workload Deployer Interface. Table 1 identifies script package parameters specific to prerequisites, which need to be met before launching the deployment.
Table 1. Software location parameters
|Parameter name||Parameter description||Example|
|The drive letter, which will be used to map the network drive on to. This network drive is the one that will hold the software repository.|
|The shared folder address in Microsoft Windows specific share format. Do not append the last backslash of the path.|
| User, which has
access to the |
| This is the
Table 2 identifies the script package parameters specific to the Microsoft SQL product.
Table 2. Microsoft SQL Server parameters
|Parameter name||Parameter description||Example|
|This will be the administrator user of the Microsoft SQL Server. Additionally, if the value differs from "Administrator" and it is, for example, "John", then "John" will be added to the operating system Administrators group.|
| This is he
|SA is an internal SQL administrative account. In this field, its password is required.|
|This is the Microsoft SQL desired instance name.|
| This is the home
directory of the instance |
|This is the account that will be used to run the default Microsoft SQL services.|
|This is the
password for the Windows account given as a value to the
| This is the
serial of the Microsoft SQL product. If you want to install
the trial version of the SQL product, type in the string
| This is the port
to be used for connecting to |
- The script package creates the local users, respective to the operating system on which the Microsoft SQL product is deployed, automatically if they do not already exist on the system.
- If you are using domain-registered hosts, the domain users and groups must be created on the Active Directory domain controller before this script package is run. For details on how to achieve this, see the notes in the next section, Step 3: Acquiring the script package prerequisites.
Step 3: Acquiring Script Package prerequisites
This section describes the script package prerequisites without getting into the fine details of the operating system image creation process. You will find information on how to build these images using the IBM Construction and Composition Toolkit.
Table 3 identifies the directory structure exposed by the
sharePath parameter (for reference, see Table 1). Additionally, Table 3
provides guidance on the content that needs to be placed in this directory
Table 3. Software packages
| This is the
Microsoft SQL installation package. See Table 1 for the
| This is the
Microsoft SQL Service Pack package. See Table 1 for the
|This is the jre that you can download from the Java SE Runtime Environment 6 Downloads page.|
The software above should already exist in the specified location before you start the deployment.
Table 4 identifies the free space needed on the operating system disks.
Table 4. Space required
|Drive/Location||Minimum free space needed||Additional notes|
|10 GB|| This location
will hold the temporary location needed for the installation
as well as the standard
|5 GB|| The drive holding
the directory that is defined in the |
All the prerequisites related to the operating system part, on which you will be deploying this script package, have to be fulfilled by the guest operating system image by default. You do not have the option of modifying this image when provisioning a virtual system pattern.
- The user access control (UAC) must be disabled on the Windows operating system part before running this script package, or the Windows operating system part should already have the UAC setting disabled. For help on disabling the UAC, refer to Turn user account control on or off.
- In the use case in which domain users or groups are used, the virtual machine's operating system must adhere to a domain. This is done by using the Windows OSPreparation script package. For details on how to use this script package and the parameters exposed, see Getting started with the Windows OS Preparation Script Package V1.
Step 4: Deploying the script package within a virtual system pattern
This section describes the steps to create a virtual system pattern and deploy it in your PureApplication System environment. Additionally, you will find details on how to check the status of your deployment.
Preparing a virtual system pattern for deployment
The script package comes in a form of a zip archive using the following naming convention:
In some cases, when the product (that the script package installs and configures) is installed on multiple platforms, the platform is then specified in the name to avoid confusion.
In PureApplication System terminology, this is called a script package. This script package has to be part of a virtual system pattern, which in the end is deployed and managed under the form of a virtual system instance.
To create and deploy a script package, follow these steps:
- Login to your environment's IBM Workload Deployer interface.
- To add the script package you have received, click (on the upper bar)
on Catalog > Script Packages and
press the green plus icon in the menu bar. Type the name for the
script package to be created and press OK, as shown
in Figure 1 and Figure 2.
Figure 1. Open the script packages section
Figure 2. Name the script package
- Now import the script package archive you have been provided by
clicking on the grayed out Browse from the right side
of the Script package file field. Select the archive
from your local file system and then click the Upload
button, as shown in Figure 3.
Figure 3. Import a script package archive
- Prior to using the script package, you need to accept the license. To
do this, follow the highlighted areas shown in Figures 4 through 7.
Figure 4. Bring up the license window
Figure 5. List the license contents
Figure 6. Accept the license
Figure 7. Finish the license acceptance process
- Immediately after you have imported your script package (while still in the Script Package view), you have the option to select when this script package will be executed (see Figure 8). The Execute field needs to be set to one of the two values shown in Table 5.
Table 5. Script Packages Execution settings
|Value||When to select|
|at virtual system creation||Select this when your OS Part (operating system image) on which this script package will be run has satisfied all the prerequisites described in Step 2: Identifying the script package parameters and Step 3: Acquiring the script package prerequisites, as well as any external dependencies you might have in your desired topologies (for example, an external database).|
|when I initiate it||Select this when the prerequisites are not met or external dependencies require an action first.|
- If you selected when I initiate it (see Figure 8)
after you built your virtual system pattern and you click
Deploy (see Figure
13), this creates your virtual host and installs the operating
system. However, hold off on executing the script package until this
is manually invoked. Figure 8 shows the script package option that has
been discussed in this section.
Figure 8. Execute options for a script package
- Against each of the script packages, you will see the Execute now button, which you have to click and follow the on screen instructions to execute your script package. Figure 15 outlines the script package se ction of a virtual system instance, where the Execute now button is found (in the referenced figure, the script package has not executed yet).
- To create a virtual system pattern, click (on the upper bar) on
Patterns > Virtual Systems. Then click on the
green plus icon in the menu bar, provide a name and a description for
the virtual system pattern, and press OK, as shown in
Figure 9 and Figure 10.
Figure 9. Select a virtual system pattern
Figure 10. Create a virtual system pattern
- To compose or orchestrate the newly created virtual system pattern,
click on the Edit button on the upper right side of
the bar, as shown in Figure 11.
Figure 11. Edit mode of your virtual system pattern
- In the new screen, drag and drop the parts from the palette on the
left to the editing area. You will need to add a Windows Server 2008
R2 64-bit image and the script package created in the previous steps.
When finished, click on Done Editing as shown in
Figure 12. Edit your virtual system pattern
You have created a virtual system pattern, which you can deploy as many times as you need in your environment.
- Next, deploy the new virtual system pattern. In your IBM Workload
Deployer console, go to Patterns> > Virtual
Systems. Click on the previously created system pattern.
On the right side of the upper bar, click on the
Deploy button as shown in Figure 13.
Figure 13. Deploy your virtual system pattern
- After clicking the Deploy button, the following
information is requested:
- Virtual System Name: This is the name of the virtual system pattern instance.
- Environment: Your IBM Workload Deployer administrator should provide the necessary information.
- OS Part parameters: This is where you complete the values for the required operating system level parameters.
- Script Package parameters (found under the OS Part sub page): You will find details in this article.
Note that the only mandatory fields are those starred (*) and the Instance Name.
After completing the field values as they are documented in Step 2: Identifying the script package parameters, click on the OK button.
Your virtual system pattern is now deploying. The deployment will finish when either the first, or both of the following actions are completed:
- The operating system of the deployed virtual machine has been installed and the virtual machine is now started.
- The script packages within the virtual system pattern you are deploying have been successfully executed.
The execution of the script packages in the later action above is conditioned by the value set for the "Execute Now" option of each of the script packages added to the specific virtual system pattern, which is described earlier in this guide.
Step 5: Checking the status of your deployment
- To check the status of your virtual system pattern deployment, click
on Instances > Virtual System in the upper blue
bar, as shown in Figure 14.
Figure 14. Check status of the virtual system pattern deployment
- In the newly opened window you will find, on the left frame, the Virtual System Pattern instance you have created. Click on it. If there are too many instances, you can use the search filter (which you can find at the top of the left frame) and type in some characters. This is part of the virtual system pattern instance name you had created earlier.
- At this point, in the frame on the right side of the page, there will
be details about your deployment. However, at this stage, the
following two are the most important:
- Current status: This shows what the current deployment is doing. For example, starting virtual image, deploying pattern, registering virtual image, and so on.
- Virtual machines: This provides information
about the current status of the virtual machine, its hardware
and network details, as well as a status of the script
packages that have been deployed, currently in deployment
process, or that can be deployed. The network details provide
the virtual machine's IP address and hostname. Figure 15
provides an example and includes the areas of most interest
within the deployment of a script package.
For the script package run, Figure 16 describes a situation where the script packages have been executed at virtual system deployment, while Figure 15 shows an example of a Script Package set to execute only "when I initiate it". That fact is confirmed by the (none) attribute, which signifies the absence of logs for the specific script package (since it has not been executed yet).
Figure 15. Script package status with "when I initiate it" execute option
Figure 16. Information about the IP and script package status
- To connect to the deployed virtual machine, a connection can be made to the IP outlined in Figure 16, using either the Remote Desktop for Windows or the ssh client for Linux/Unix.
- In Figure 16, the log files are displayed against each script. The
remote_std_out.logoutlines what the script package has done during deployment and contains both errors and details of a normal script package run. In a successful deployment, you see the following lines at the end:
SPiN ended: successfully :-) ===========================End of SPIN LOG ========================= INFO:Java(TM) 6 Update 34 (64-bit) is installed INFO:Uninstalling: Java(TM) 6 Update 34 (64-bit) Version: 6.0.340 INFO:Successfull uninstall
remote_std_out.log file at the end of each deployment will provide
the latest level of assurance for a successful execution.
This article described how to deploy a Microsoft SQL server using one of the IBM Pattern Lab automation assets. It defined the topology used and the requirements and capabilities of this automation asset.
- Other IBM Pattern Lab quick start guides:
- IBM PureSystems web site
- Using the Image Construction and Composition Tool
- Creating Windows images for use in IBM PureApplication System
- IBM PureApplication System Information Center
- IBM PureSystems Centre
- IBM PureSystems resources on developerWorks
Dig deeper into Cloud computing on developerWorks
Get samples, articles, product docs, and community resources to help build, deploy, and manage your cloud apps.
Crazy about Cloud? Sign up for our monthly newsletter and the latest cloud news.
Software development in the cloud. Register today to create a project.
Deploy public cloud instances in as few as 5 minutes. Try the SoftLayer public cloud instance for one month.