Creating a vSphere Template – Windows Server 2008 R2 with SQL Server 2008 R2

Configure Windows

First, Install Windows Server 2008 R2 and configure it to be an efficient template using the instructions on the following websites. Note that not everything is really necessary; use your own discretion.

Configuration Files

Next, make 2 configuration files. One is for the Image Preparation step, the other for Image Completion. The files given below assume that you’re using my optimized sql install instructions here: Optimized SQL Server Express R2 Installation. Make sure to change the “DOMAIN\SQL Admins” user in the completion image config file.

Shared Features Installation Config File:
;SQLSERVER2008 Configuration File
[SQLSERVER2008]
IAcceptSQLServerLicenseTerms="True"
ACTION="Install"
FEATURES=SSMS,SNAC_SDK
HELP="False"
INDICATEPROGRESS="False"
QUIET="False"
QUIETSIMPLE="True"
X86="False"
ROLE="AllFeatures_WithDefaults"
ENU="True"
CUSOURCE="C:\workingtemp\SQL2008ExpressR2CU4\CU"
ERRORREPORTING="True"
INSTALLSHAREDDIR="C:\Program Files\Microsoft SQL Server"
INSTALLSHAREDWOWDIR="C:\Program Files (x86)\Microsoft SQL Server"
SQMREPORTING="True"

Image Prep Config File:
;SQLSERVER2008 Configuration File
[SQLSERVER2008]
CUSOURCE=".\CU"
QUIETSIMPLE=True
IAcceptSQLServerLicenseTerms="True"
ACTION="PrepareImage"
FEATURES=SQLENGINE
INSTALLSHAREDDIR="C:\Program Files\Microsoft SQL Server"
INSTALLSHAREDWOWDIR="C:\Program Files (x86)\Microsoft SQL Server"
INSTANCEID="MSSQLSERVER"
INSTANCEDIR="D:\SQLData"

Image Completion Config File:
[SQLSERVER2008]
IAcceptSQLServerLicenseTerms="True"
INSTANCEID="MSSQLSERVER"
ACTION="CompleteImage"
HELP="False"
INDICATEPROGRESS="False"
QUIET="False"
QUIETSIMPLE="True"
ENU="True"
ERRORREPORTING="True"
SQMREPORTING="True"
INSTANCENAME="MSSQLSERVER"
AGTSVCACCOUNT="NT AUTHORITY\NETWORK SERVICE"
AGTSVCSTARTUPTYPE="Automatic"
SQLSVCSTARTUPTYPE="Automatic"
FILESTREAMLEVEL="0"
ENABLERANU="True"
SQLCOLLATION="SQL_Latin1_General_CP1_CI_AS"
SQLSVCACCOUNT="NT AUTHORITY\SYSTEM"
SQLSYSADMINACCOUNTS="DOMAIN\SQL Admins"
SQLUSERDBLOGDIR="E:\SQLData\MSSQL10_50.MSSQLSERVER\MSSQL\Data"
SQLTEMPDBLOGDIR="E:\SQLData\MSSQL10_50.MSSQLSERVER\MSSQL\Data"
ADDCURRENTUSERASSQLADMIN="True"
TCPENABLED="0"
NPENABLED="0"
BROWSERSVCSTARTUPTYPE="Disabled"
RSSVCACCOUNT="NT AUTHORITY\NETWORK SERVICE"
RSSVCSTARTUPTYPE="Automatic"
RSINSTALLMODE="FilesOnlyMode"

Prepare SQL

References:

Ok, so this is going to look almost exactly the same as a regular SQL installation. The key is modifying the configuration file. Use my blog post as a guide with the additional steps below.

Optimized SQL Server Express R2 Installation

  1. Once you complete all of the steps down to ‘Installation’, the first run of the installer should use the “Shared Features Installation Config File”. This will install your shared features.
  2. Next, run the installer with the “Prepare Image” configuration file you made above.
  3. After the template is deployed, you have to run the following command to complete SQL installation:
    setup.exe /configurationFile=<pathto_sqlconfig-completeImage.ini>
Advertisements

One thought on “Creating a vSphere Template – Windows Server 2008 R2 with SQL Server 2008 R2

  1. Pingback: Table of Contents | windowsmasher

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s