Using CA AppLogic® › Appliance Developer Guide › Creating Appliances › Distribution Installations › SQL08X/WG/D/W/S/E_03: Microsoft SQL Server Database Appliances - Installation Reference

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

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

• SQL08X_03 - WIN03S
• SQL08WG_03 - WIN03S
• SQL08D_03 - WIN0364DC
• SQL08W_03 - WIN0364DC
• SQL08S_03 - WIN0364DC
• SQL08E_03 - WIN0364DC

First create the Windows Server appliance WIN03y as described in the Windows Server 2003 Single CD Installation Reference or Windows Server 2003 Two CD Installation Reference topics.

Note: In the following instructions, the y placeholder in WIN03y is for the Windows edition that the appliance/app is based upon (S for Standard, DC for DataCenter). The y placeholder in SQL08y_03 is for the SQL edition that the appliance is based upon (X for Express, WG for Workgroup, D for Developer, W for Web, S for Standard, E for Enterprise).

To install and configure the SQL08y appliance

1. Create an application that contains an instance of WIN03y and branch the instance (referred to below as a singleton).
2. Configure the singleton's default resources to cpu=1 and memory=1G to speed up the appliance creation process.
   1. Select the singleton in the infrastructure editor.
   2. Under the Appliance menu select Resources.
   3. Modify the default resources as specified above.
3. Ensure the WIN03y boot volume size is greater than 8GB.
4. Edit the class and enable the external interface:
   1. Select the singleton in the infrastructure editor.
   2. Under the Appliance menu select Modify Boundary.
   3. Select the Interfaces tab.
   4. Select the External Interface checkbox under Raw. Interfaces
5. Edit the class and add a mandatory placeholder volume (name: data; mount on D:\).
6. Create an application volume to use temporarily as the placeholder volume (filesystem: ntfs03; size: 6GB).
7. Start the application and open up the graphic console of the singleton using the CA AppLogic® GUI (on the Applications tab, select your application and login to the graphical console using the Login (graphic) button at the top of the page).
8. Login to the Windows appliance as the administrator.
9. If you have not already installed the latest versions of both the Windows Installer and the .NET Framework, do so now:
   1. Configure the external interface with usable network settings (this is the first enumerated network interface):
      • Access Control Panel, Network Connections, Local Area Connection X, Properties, Internet Protocol (TCP/IP), Properties; click on Use the following IP address and enter usable values for your grid (IP Address, netmask, gateway, DNS server)
      • Or, in the command shell:
      • netsh interface ip set address name="Local Area Connection X" static [ip-address] [netmask] [gateway] 1
      • netsh interface ip set dns name="Local Area Connection X" static [dns-ip]
   2. Open Internet Explorer, search for Windows Installer 4.5; download and install it (do not reboot)
   3. Open Internet Explorer, search for .NET Framework 3.5 SP1; download and install it (do not reboot)
10. Enable virtual memory for the appliance -- in a command shell:
    • C:
    • cd \WINDOWS\system32
    • cscript ./pagefileconfig.vbs /create /sys /vo d:
11. Restart the application
12. Install the desired version of SQL Server 2008. A complete distribution source should be used: ISO-image or a full redistributable package. If you are downloading an extractable archive of SQL Server, 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.
13. Extract redistributable package as following:
    • SQLEXPRADV_x86_ENU.exe /Q /X:D:\
14. Use an appropriate version of the SQL setup configuration file ConfigurationFile_x86.ini or ConfigurationFile_x64.ini and launch the installation as following:
    • setup.exe /q /action=Install /configurationfile=D:\ConfigurationFile_x{86|64}.ini /MEDIASOURCE=D:\ /sapwd="manager" /ASSYSADMINACCOUNTS="%COMPUTERNAME%\Administrator" /SQLSYSADMINACCOUNTS="%COMPUTERNAME%\Administrator" /TCPENABLED=1
      Note that MEDIASOURCE should point on the root of the SQL installation folder.
15. 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.
    1. To find the internal IP address of the controller, in a command line shell execute ipconfig /all and note the IP address of the DHCP server for the last enumerated interface (for example, Local Area Connection 5).
    2. Point IE at http://IP-address:8080/download/ and download the current Windows SQL msi (for example, SQL_Windows-1.0.6-1.msi):
    3. Right-click on the msi file and select Save Target As to download the file to the desktop.
    4. Double-click on the msi file on the desktop to perform the installation.
    5. Delete the msi file and empty the Recycle Bin.
    6. Delete junction points on Windows volumes as described in the Windows Server appliance WIN08y.
16. Clean-up drive D: remove all SQL-related installation files, including ConfigurationFile.ini.
17. In a Cygwin bash shell:
    1. Set a new complex password (for example, net user administrator pq398hpaowht0293j^LWOIFH9htfw9jfe).
    2. Exit the SSH session.
    3. SSH into the appliance and execute rm -f ~/.bash_history /appliance/passwd.stamp.
18. Stop the application and edit the singleton boundary.
    1. Change the class icon color to red
    2. Change the class name to SQL08y_03
    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. Remove the external interface
    6. Right-click on the singleton and select Attributes. Change the instance name to SQL08y_03.
    7. Modify the terminals:

h. Add the following properties:

i. Set the appliance resources:

19. Verify the health of the singleton's boot volume by executing the following command from the web shell:

vol fscheck name_of_volume 

20. Move SQL08y_03 to a catalog (we recommend system_ms).

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