Users Guide

Template – deploy SQL Server 2012

ASM includes a default template that allows you to deploy SQL Server 2012. To configure this template,

you must provide a valid Microsoft SQL Server 2012 ISO and then copy the application location to the

ASM virtual appliance.

To configure ASM virtual appliance:

1. Log in to ASM virtual appliance as delladmin. The default delladmin credentials are delladmin/

delladmin.

NOTE: To login to ASM 8.2 user interface, you need to use the username asadmin with the

default password as admin.

2. You must copy Microsoft SQL Server 2012 ISO to the /var/lib/razor/repo-store/ directory.

3. Unpack Microsoft SQL Server 2012 ISO into CIFs share on the virtual appliance. To perform this task,

run the following commands:

cd /var/lib/razor/repo-store mount -o loop <SQL2012>.iso/mntrsync -

a /mnt/ /var/lib/razor/repo-store/ SQL2012umount /mntrm SQL2012.iso

4. On the ASM home page, in the left pane, click Templates, select the Deploy SQL Server 2012

template, and then click Clone.

5. In the Create Template dialog box, enter a name, category, and description. Click Save.

6. On the Template Builder page, click a storage component, click Edit in the box that is displayed, and

then configure the following settings in the Storage Component dialog box. Repeat this step for

each storage components.

a. Under Storage Settings, configure the following:

1. From the Authentication drop- down list, select the one of the following authentication

types based on your environment: IQN/IP or CHAP.

2. If you have selected the authentication type as CHAP, enter the Chap username and Chap

secret for the storage volume

3. If you have selected the authentication type as IQN/IP, enter the Initiator IQN or IP

address for the storage volume.

NOTE: If you do not update these password values, the template will not deploy correctly.

There is no value to passwords in the default template even if a masked value appears.

CHAP user names and secrets should be the same on both volumes if CHAP

authentication is used.

b. Verify the Storage Volume Name.

c. Click Save.

7. On the Template Builder page, click a server component, click Edit in the box that is displayed, and

then configure the following settings in the

Server Components dialog box. Repeat this step for each

server components.

a. Under OS Settings, enter the Administrator password.

b. Under Network Settings, configure the Hypervisor Management Network, Hypervisor vMotion

Network, and Workload networks.

c. Click Save.

8. On the Template Builder page, click the cluster component, and configure the following:

a. Under Cluster Settings, from the Target Hypervisor drop-down list, select the target vCenter.

b. Verify if you want to create a new datacenter or cluster inside your vCenter instance.