Unsupported content This version of the documentation is no longer supported. However, the documentation is available for your convenience. You will not be able to leave comments.

Creating a SQL Server 2008 cluster on Windows 2008 R2 service offering


This topic describes the tasks that you must perform in BMC Cloud Lifecycle Management to create the service offering that the end user can then use to provision the application infrastructure (for example, an OS and an application package). It includes the following topics:

To create the service and the service offering

In the BMC Cloud Lifecycle Management Administrator console, you must add a service and a service offering.

To create a service

  1. From the BMC Cloud Lifecycle Management Administration Console, click the vertical Workspaces menu on the left side of the window, and click Service Catalog.
  2. In the Service Catalog, click Create a New Serviceservicecatalog_newservice_button.png.
  3. Enter the service name.
  4. For Type, select a service type.
    • Business service — Services that customers use and that show the customer view of services, such as email or an online store.
    • Technical service — Supporting IT and infrastructure resources required to support business services that are not visible to customers, such as servers, applications, and network CIs.

      Note

      After you select the type and save the service, you cannot change the type.

  5. Enter a description of the service.
  6. Do one of the following actions:
    • To create the service offering, click Apply.
    • To create the service offering later, click Save to save your selections and close the window.

To create a service offering

  1. From the BMC Cloud Lifecycle Management Administration Console, click the vertical Workspaces menu on the left side of the window, and click Service Catalog.
  2. From the Service Catalog, edit or create a service.
    In the Service Offering tab, a default service offering is available, which you can edit.
  3. Click Create a New Service Offering.
  4. In the General Information tab, define the options described in the following table. 

    Option

    Description

    Default Service Offering

    Enable this option to make the selected service offering the default for the service. Unless users select a different service offering, the default service offering is used.

    Name

    A short, descriptive name for the service offering.

    Description

    A more detailed description of the service offering.

    Service Blueprint

    Specify the software and hardware to associate with the service offering by selecting one of the available blueprints.

    Service Deployment Definition

    Specify how to deploy the selected service blueprint. From the list, select a service deployment definition that is available for the chosen service blueprint.

  5. Add a Base Customer Price to define the amount charged to the customer for the service offering.
  6. Add a Base Deployment Cost to define the amount that it costs to provide the service offering.
  7. Click Apply.
    This action activates the Options tab. You now also can create a requestable offering (for example, a request definition or a post-deploy action). For additional information, see Creating-a-requestable-offering in the BMC Cloud Lifecycle Management online technical documentation.

To make the provisioning request

  1. Access Workspaces > Service Instances to display the Service Instances workspace, and click New Service Request.

    serviceinstances_request1.png
  2. In the New Service Request dialog box, click the server provisioning service you want to display the Submit Request dialog box.To complete the Service Request for SQL Server cluster, specify the following Parameters:

    ClusterParams.png

    Parameter

    Description

    Cluster Group

    Name of the Cluster group

    Cluster Name

    Name of the Cluster

    Cluster Static IP

    IP Address to access the Cluster

    Cluster Subnet Mask

    SubnetMask for the class of the IP

    DNS IP Address

    IP Address of DNS Server

    Domain Name

    Name of the Domain to which all VM will join.

    Domain Service User Name

    SQL Server service user name

    Domain Service User Password

    Domain user service account password

    Confirm

    Confirm domain user service account password

    Domain User Name

    Admin user name of the Domain

    Domain User Password

    Admin username password of the domain

    Confirm

    Confirm admin username password of the domain

    Failover Cluster First Static IP

    Failover Cluster IP address.

    Instance ID

    ID for SQL Server instance

    Storage Name

    Name of the Storage to configure disk for nodes

  3. Enter the data in the required fields to complete the request for an instance of the service request. You can click Next to review the details.
  4. Click Submit. The request is added to the Pending Activity list in the Service Instances window.

The request status is displayed in the Pending Activity list of the Service Instances window. You can double-click on the service request to see its detailed information.

For more detailed procedures, see Requesting cloud services.

To validate the provisioned components

After provisioning the blueprint, you can validate the SQL Server cluster 2008 R2 components setup in your environment.

Component name

How to verify

Results

SQL Server cluster 2008 R2

  • Click Start > Run.
  • Type Ssms.exe and click OK to open the Management Studio.

Management Studio displays the Connect to Server dialogBox.

Connect using Management Studio

  • From Connect to Server DialogBox, select the following options:
    • Server type: Database Engine
    • Server name: localhost
    • Authentication: Windows Authentication
  • Click connect.

Management studio connects to the database.

Failover Cluster test

  • Login to the System with Domain ID.
  • Click on Start ---Go to Administrative Tools---Click on Failover Cluster Manager.

It displays failover cluster manager console.

Where to go next

After you have created the service offering, the cloud end user can request a service offering from the My Cloud Services console. To view a list of tasks that the cloud end user can perform to manage your cloud services, see Managing cloud services in the BMC Cloud Lifecycle Management online technical documentation.

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*