Using CA AppLogic® › Appliance Developer Guide › Appliance Kit › Appliance Cookbook › SQL08X/WG/D/W/S/E_08: Microsoft SQL Server Database Appliances - Installation Reference

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:

• SQL08X_08 - WIN08S
• SQL08WG_08 - WIN08S
• SQL08DC_08 - WIN0864DC
• SQL08W_08 - WIN0864DC
• SQL08S_08 - WIN0864DC
• SQL08E_08 - WIN0864DC

Note: 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.

To install and configure the SQL08y appliance

1. Create the Windows Server appliance WIN08y using Windows Server 2008 Base Server Class Installation Reference.
2. Make a new singleton from the specified base class (WIN08S or WIn0864DC):
   • Create a new application. Include an instance of the base class and branch the class. Assign 1 cpu and 1GB of memory to the singleton.
   • Start the application and SSH into the singleton. Set a new Administrator password (net user administrator password - select a password).
   • Access the graphic console of the singleton in one of the following two ways:
     • Select the application within the application list in the CA AppLogic® GUI and click the icon for Login (graphic).
     • Open the application in the CA AppLogic® editor and select the singleton. Use the pull-down Appliance menu to select Login (graphic).
3. Stop the application. Right-click appliance in infrastructure 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.
4. Add a new placeholder volume (name: data; mount on D:\). Mark it as mandatory.
5. Right-click the infrastructure editor and select manage volumes. Add an application volume to use temporarily as the placeholder volume (filesystem: ntfs08; size: 8GB).
6. Start the application and login to the graphic console of the singleton as Administrator.
7. Enable virtual memory for the appliance:
   1. Start, Control Panel, System (System and Security), Advanced systems settings, Advanced, Performance Settings, Advanced, Virtual memory, Change.
   2. Leave the C drive with no paging file and set the D drive to use a system managed page file size.
   3. Click Set.
8. Restart the application.
9. 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.
10. Extract the redistributable package as in the following example:

    SQLEXPRADV_x86_ENU.exe /Q /X:D:\ 
    

11. Use an appropriate version of the SQL setup configuration file ConfigurationFile_x86_R2.ini or 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.

    Note: If SQL installation requires .NET framework enabled, then go to server manager, features. Enable .NET framework 3.5.1 feature and run the above installation command again.

12. 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.
    • To find the internal IP address of the controller, in a command line shell execute the following and note the IP address of the DHCP server for the last enumerated interface (for example, Local Area Connection 5):

      ipconfig /all
      

    • Point IE at http://IP-address:8080/download/ and download the current Windows SQL msi (for example, SQL_Windows-1.0.6-1.msi):
      • Right-click the msi file and select Save Target As to download the file to the desktop.
    • Double-click the msi file on the desktop to perform the installation.
    • Delete the msi file and empty the Recycle Bin.
    • Delete junction points on Windows volumes as described in the Windows Server appliance WIN08y.
13. Clean-up drive D: remove all SQL-related installation files, including the setup configuration file.
14. In a Cygwin bash shell
    • Set a new complex password (for example, net user administrator pq398hpaowht0293j^LWOIFH9htfw9jfe).
    • Exit the SSH session.
    • SSH into the appliance and execute the following command:

      rm -f ~/.bash_history /appliance/passwd.stamp. 
      

Stop the application and edit the class:

1. Change the class icon color to red.
2. Change the Documentation URL to the following:

   http://doc.3tera.com/AppLogic35/index.htm?toc.htm?CatDatabaseAppliancesSQL.html
   

3. Change the class name to SQL08y_08.
4. 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))
5. Change class category to Database Appliances
6. Right-click the singleton and select Attributes. Change the instance name to SQL08y_08.
7. Modify the terminals (delete net and out terminals):

g. Add the following properties:

h. Set the appliance resources:

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

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