Posted in
Windows Server |
No Comment | 3,606 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:
3) Make a new file called “SetupComplete.cmd” under “C:\Windows\Setup\Scripts”. Path should be:
C:\Windows\Setup\Scripts\SetupComplete.cmd |
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 |
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" |
;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.