Previous Topic: SQL08X/WG/D/W/S/E_03: Microsoft SQL Server Database Appliances - Installation Reference

Next Topic: Linux Appliance Installation

SQL08X/WG/D/W/S/E_08: Microsoft SQL Server Database Appliances - Installation Reference

Each SQL08y_08 appliance is built using the following generic Windows Server appliance as a base class:

First create the Windows Server appliance WIN08y as described here.

In the following instructions, the y placeholder in WIN08y is for the Windows edition that the appliance/app is based upon (S for Standard, DC for DataCenter). The y placeholder in SQL08y_08 is for the SQL edition that the appliance is based upon (X for Express, WG for Workgroup, DC for DataCenter, W for Web, S for Standard, E for Enterprise). All of the SQL editions used to create the SQL08y_08 appliances are based on the R2 editions of SQL Server 2008.

  1. Make a new singleton from the specified base class (WIN08S or WIn0864DC):
  2. Stop the application. Right-click on appliance in application editor and go to volumes tab. Resize the singleton boot volume to 13GB. This is an approximate size. The typical SQL install requires 4-5 GB of free disk space, and after this install there should be about 1GB of free space on the singleton boot volume. Adjust the size according to the free space on your singleton.
  3. Add a new placeholder volume (name: data; mount on D:\). Mark it as mandatory.
  4. Right-click on appliance in application editor and select manage volumes. Add an application volume to use temporarily as the placeholder volume (filesystem: ntfs08; size: 8GB).
  5. Start the application and login to the graphic console of the singleton as Administrator.
  6. Enable virtual memory for the appliance:
  7. Restart the application.
  8. Install the desired version of SQL Server 2008 R2. A complete distribution source should be used: ISO-image or a full redistributable package. If you are downloading an extractable archive of SQL Server R2, download and extract it on the D volume. When using an ISO-image, it may be mounted as a separate drive or extracted on D also. From there, it can be installed to C.
  9. Extract the redistributable package as in the following example:
  10. Use an appropriate version of the SQL setup configuration file (ConfigurationFile_x86_R2.ini/ConfigurationFile_x64_R2.ini) and launch the installation as following:
    setup.exe /q /action=Install /configurationfile=D:\ConfigurationFile_x{86|64}_R2.ini /MEDIASOURCE=D:\ /sapwd="manager" /ASSYSADMINACCOUNTS="%COMPUTERNAME%\Administrator" /SQLSYSADMINACCOUNTS="%COMPUTERNAME%\Administrator" /TCPENABLED=1 
    

    MEDIASOURCE should point on the root of the SQL installation folder.

  11. Install the SQL msi. This self-executing installer can be downloaded from the grid controller through the default interface of the singleton. This interface has already been properly configured through DHCP.
  12. Clean-up drive D: remove all SQL-related installation files, including the setup configuration file.
  13. In a Cygwin bash shell

14. Stop the application and edit the class:

  1. Change the class icon color to red.
  2. Change the class name to SQL08y_08.
  3. Change the class description (for example, SQL Server Appliance - based on Windows Server 2003 Enterprise Edition R2 32/64-bit and SQL Server 2008 Enterprise (v1.0.0-1))
  4. Change class category to Database Appliances
  5. Modify the terminals (delete net and mon terminals):

Terminal Name

Direction

Protocol

in

In

any

mon

Out

cce

Add the following properties:

Name

Type

Default

Constraints

read_only

String

off

on,off

sa_password

String

(empty)

 

user_db_name

String

(empty)

 

user_login

String

(empty)

 

user_password

String

(empty)

 

max_connections

Integer

0

min = 0, max = 999999

Set the appliance resources:

Resource

X/WG Minimum

DC/E/S/W Minimum

X/WG Maximum

DC/E/S/W Maximum

X/WG Default

DC/E/S/W Default

CPU

0.25

0.25

4

32

0.5

0.5

Memory

768MB

1G

4G

64G

1G

1G

Bandwidth

1 Mbps

1 Mbps

2 Gbps

2 Gbps

100 Mbps

100 Mbps

15. Move SQL08y_08 to a catalog (system_ms is recommended).

16. The SQL08y_08 appliance is now ready for use in your CA 3Tera AppLogic applications.