Takeaway: Islam Gomaa explains how to deploy SQL server 2012 Sp1 as a service oriented using Microsoft System Center Virtual machine Manager 2012 Sp1 using Windows 2012.
There are four (4) main steps on the deployment process in order to deploy SQL Server as a service using SCVMM.
1- Prepare the VM
It’s strongly recommended to follow the SQL Server instructions on a VM to prepare an image. You can find how to do it with UI from here: http://blogs.msdn.com/b/petersad/archive/2009/12/17/sql-server-2008-r2-sysprep-step-by-step.aspx
2- Create SQL Profile
The process of deploying SQL Server as a Service with System Center 2012 SP1 VMM starts with creating a SQL Server Profiles that contain the following
a. Deployment Name, Instance Name, Instance ID, Product Key and the Installation account
3- Create a VMM Service template
VMM runs SQL setup for you–after joining the VM to the domain, thus completing the other half of the SQL sysprep process.
The SQL Server service template, seen in below diagram view, includes in the center, a single machine tier. That tier consists of one VM that includes a SQL Server Profile deployment to install as part of this VM instance.
4- Deploy the service
- Select the Service Template for the SQL Server service and click the Configure Deployment button in the ribbon.
- Type your name for this SQL Server application instance (this will not be the name of the VM), and in the drop-down list, optionally change which private cloud to deploy the service into, and click OK.
- A diagram view of the service that is about to be deployed will pop up. If everything looks OK, click the Deploy Service button in the ribbon.