How to create and deploy SQL Server with SCVMM 2012 SQL Profile – Part 1–Create SQL Server Image / Template

imageIn the first part we will create an sysprep’ed image with SQL 2008 R2 on Windows Server 2008 R2. This will be used as a base for our deployment. I am not going to go into details to slipstream service packs of SQL server into the installer. There is a great article already published on SQL Server Setup blog.

Ok, lets get to work.

First, lets deploy Windows server. Since I have already built Sysprep’ed image of Windows Server, I will deploy a new VM using template. I will share Sysprep steps here which can be used to sysprep Windows Server too. To Deploy a new VM which will become our SQL server:

image

image

I will leave other settings up to you, pretty straightforward.

Once the new VM is ready: Copy the sql installation to a directory (do not forget the name of this directory, we will need it). The source could possibly be on a network share but your deployed VM/service need to be able to access it. 

image

Run setup in this directory and install the required components (.NET Framework):

image

Then select “Image Preparation of a stand-alone instance of SQL Server”:

image

Couple next’s and then accept license, next, install required files, next…
Then, select the features you intend to use in the image (you can typically select all to use one image for SQL deployments, it is up to you)

image

Take a note of Instance ID. This will be needed later. This is not an instance name.

image

Next, and confirm and Click prepare

image

After it completes, I will go ahead and also install SQL management studio (SSMS) before sysprepping. The process is similar.

image

image

image

After the installation completes, close all SQL setup files. Now, need to sysprep the image: 

   1:  C:\Windows\system32\sysprep\sysprep.exe

 

After Running Sysprep, select OOBE, Generalize, and Shutdown as seen below:

imageimage

The image is now ready to use.

 

 

 

image

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)
Data Center Design (VCAP-DCD)
:: VTSP (VMware Certified Technical Sales Professional 5)
:: MCSE(Microsoft Certified Solutions Expert) – Private Cloud 2012
:: CCEE(Citrix Certified Enterprise Engineer)
Bulent ToluBulent ToluBulent ToluBulent Tolu Bulent Tolu
Bulent Tolu

One Comment

  1. NM-BG says:

    Very good Article–

    Thanks

Leave a Reply