search
Categories
Archive
Blogroll

Badges

Microsoft PowerShell MVP
MCSE
Sponsors

VirtualMetric
Cozumpark Bilisim Portali
How to create SQL Server 2012 template on Hyper-V
Posted in Windows Server | No Comment | 514 views | 14/08/2013 09:22

You can create Microsoft SQL Server 2012 template on Hyper-V if you want to do unattended setups.

Follow the steps:

1) Install Windows Server 2012, do latest updates and your customizations.

2) Make a new folder called “Scripts” under “C:\Windows\Setup”. Path should be:

C:\Windows\Setup\Scripts

3) Make a new file called “SetupComplete.cmd” under “C:\Windows\Setup\Scripts”. Path should be:

C:\Windows\Setup\Scripts\SetupComplete.cmd

4) Mount SQL Server 2012 DVD and copy that into a directory like “C:\PATH\OF\MSSQL\”

5) Write SQL unattended setup commands into “SetupComplete.cmd”.

C:\PATH\OF\MSSQL\setup.exe /ConfigurationFile="C:\PATH\OF\MSSQL\ConfigurationFile.ini" /q

6) You can use this ConfigurationFile.ini as a template and customize it.

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
;SQL Server 2012 Configuration File
[OPTIONS]
ACTION="Install"
ENU="True"
UIMODE="Normal"
QUIET="False"
QUIETSIMPLE="False"
UpdateEnabled="False"
FEATURES=SQLENGINE,REPLICATION,FULLTEXT,CONN,IS,BC,SSMS,ADV_SSMS
UpdateSource="MU"
HELP="False"
INDICATEPROGRESS="False"
X86="False"
INSTALLSHAREDDIR="C:\Program Files\Microsoft SQL Server"
INSTALLSHAREDWOWDIR="C:\Program Files (x86)\Microsoft SQL Server"
INSTANCENAME="MSSQLSERVER"
INSTANCEID="MSSQLSERVER"
SQMREPORTING="False"
ERRORREPORTING="False"
INSTANCEDIR="C:\Program Files\Microsoft SQL Server"
AGTSVCACCOUNT="NT Service\SQLSERVERAGENT"
AGTSVCSTARTUPTYPE="Manual"
ISSVCSTARTUPTYPE="Automatic"
ISSVCACCOUNT="NT Service\MsDtsServer110"
COMMFABRICPORT="0"
COMMFABRICNETWORKLEVEL="0"
COMMFABRICENCRYPTION="0"
MATRIXCMBRICKCOMMPORT="0"
SQLSVCSTARTUPTYPE="Automatic"
FILESTREAMLEVEL="0"
ENABLERANU="False"
SQLCOLLATION="Turkish_CI_AS"
SQLSVCACCOUNT="NT Service\MSSQLSERVER"
SQLSYSADMINACCOUNTS=".\Administrator"
SECURITYMODE="SQL"
ADDCURRENTUSERASSQLADMIN="False"
TCPENABLED="1"
NPENABLED="0"
BROWSERSVCSTARTUPTYPE="Disabled"
FTSVCACCOUNT="NT Service\MSSQLFDLauncher"

7) Sysprep your Windows Server.

After these steps, you can deploy your VHD into different VMs.



Leave a Reply