search
Categories
Sponsors
VirtualMetric Hyper-V Monitoring, Hyper-V Reporting
Archive
Blogroll

Badges
MCSE
Community

Cozumpark Bilisim Portali
How to create SQL Server 2008 R2 template on Hyper-V
Posted in Windows Server | No Comment | 4,718 views | 04/07/2011 02:29

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

Follow the steps:

1) Install Windows Server 2008 R2, 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 2008 R2 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
41
42
43
44
;SQLSERVER2008 Configuration File
[SQLSERVER2008]
INSTANCEID="MSSQLSERVER"
ACTION="Install"
FEATURES=SQLENGINE,FULLTEXT,SSMS
HELP="False"
INDICATEPROGRESS="False"
QUIET="False"
QUIETSIMPLE="False"
X86="False"
ENU="True"
UIMODE="Normal"
ERRORREPORTING="False"
INSTALLSHAREDDIR="C:\Program Files\Microsoft SQL Server"
INSTALLSHAREDWOWDIR="C:\Program Files (x86)\Microsoft SQL Server"
INSTANCEDIR="C:\Program Files\Microsoft SQL Server"
SQMREPORTING="False"
INSTANCENAME="MSSQLSERVER"
AGTSVCACCOUNT="NT AUTHORITY\NETWORK SERVICE"
AGTSVCSTARTUPTYPE="Manual"
ISSVCSTARTUPTYPE="Automatic"
ISSVCACCOUNT="NT AUTHORITY\NetworkService"
ASSVCSTARTUPTYPE="Automatic"
ASCOLLATION="Latin1_General_CI_AS"
ASDATADIR="Data"
ASLOGDIR="Log"
ASBACKUPDIR="Backup"
ASTEMPDIR="Temp"
ASCONFIGDIR="Config"
ASPROVIDERMSOLAP="1"
FARMADMINPORT="0"
SQLSVCSTARTUPTYPE="Automatic"
FILESTREAMLEVEL="0"
ENABLERANU="False"
SQLCOLLATION="Turkish_CI_AS"
SQLSVCACCOUNT="NT AUTHORITY\NETWORK SERVICE"
SQLSYSADMINACCOUNTS=".\Administrator"
ADDCURRENTUSERASSQLADMIN="False"
TCPENABLED="1"
NPENABLED="0"
BROWSERSVCSTARTUPTYPE="Disabled"
RSSVCSTARTUPTYPE="Automatic"
RSINSTALLMODE="FilesOnlyMode"
FTSVCACCOUNT="NT AUTHORITY\LOCAL SERVICE"

7) Sysprep your Windows Server.

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



Leave a Reply