How to create and deploy SQL Server with SCVMM 2012 SQL Profile – Part 3–Service Template and Deployment

imagePart3: Before creating a service template and deploy it, we need to save the vhdx created earlier to the library. You can manually copy the vhdx to the library (SQL Server Image) and then create a VM Template. After copying, refresh the library to make sure the new disk is listed.

image

I will leave other settings up to your environment. Make sure to select HA.

In Configure SQL Server Section, add the SQL Profile we created earlier, called SQLDeployment, then create the template.

image

 

To Create Service Template, select create, and then single Machine.

image

image

At this point the designer opens, you need to drag the disk and drop it on the template on the right. Then click save and validate.

imageimage

Validate and click configure deployment. Name your deployment.

image

In the deploy service screen, at the bottom, you will see properties of each component. Change it as required, name, host to deploy etc.

image

Finally, deploy!!!

image

 

After the deployment completes, you can see it is listed in the services section:

image

If you get an error during deployment, check “C:\Microsoft SQL Server\100\Setup Bootstrap\Log\summary.txt” for errors.

Bulent Tolu

Bulent Tolu

Bulent is an IT professional with Master's in MIS and 10-years of experience in broad range of Information Technologies. He is exposed to engineering/architecting, implementation/integration, and administration of various high-available IT systems and infrastructure. He has a passion to continually research, test and evaluate new technologies and follow industry best practices to secure and optimize IT systems. Currently, he lives in Istanbul and works as a Sr. Cloud Computing and Virtualization Consultant. He has a diverse knowledge and interest in Virtualization and Cloud Computing.

:: VMware Certified Advanced Professional 5
Data Center Administration (VCAP5-DCA)
:: VTSP (VMware Certified Technical Sales Professional 5)
:: MCSE(Microsoft Certified Solutions Expert) – Private Cloud 2012
:: CCEE(Citrix Certified Enterprise Engineer)
Bulent ToluBulent ToluBulent Tolu Bulent Tolu

Bulent Tolu

2 Comments

  1. Mohamed says:

    Hi , thanks for this blog.

    1. After you create the sql profile , do you need to sysprep the machine again before copying the vhdx to the library

    2. do you have any info on creating a sql cluster template / service using VMM. thanks

  2. Bulent Tolu Bulent Tolu says:

    Hi Mohamed,
    In order to prep an image with SQL, you need to follow the steps listed in part 1: http://www.cdolar.com/2012/12/how-to-create-and-deploy-sql-server-with-scvmm-2012-sql-profile-part-1create-sql-server-image-template/
    Here the last step is to sysprep after installing/prepping SQL for sysprep. Unfortunately, I have not done any cluster. Good luck!

Leave a Reply