We live in virtualization era, so in this post I’d like to show how to prepare a a Windows template with pre-intalled SQL Server. I will use a Windows Server 2012 R2 as operating system and MS SQL 2012 server. This will be a sceenshot based quick manual.
To install SQL 2012, I need to install .NET 3.5 framework on Windows 2012 R2 and while trying to do that with ServerManager, I faced following error
And solution can be found here. So I need to mount the Windows 2012 R2 ISO file in my VM, the DVD drive in my case is D: drive, so I run following command
And after few minutes I have it installed
Now I mount the SQL 2012 installation DVD and let’s start
- First step is to start SQL installation media and choose “Advanced” from menu on the left side, then click “Image preparation of a stand-alone instance of SQL Server”
- Next step is just clicking “Ok” on the checks screen
- Next step is accepting license agreement and of course I don’t want to send anything to Microsoft, they already have enough data and moreover my VM is not connected to internet 🙂
- On the Product Updates window, I’m getting error, because my VM is not connected to internet
- On another checks screen, I’m getting one warning because I don’t have internet connection
- So finally after few screens, I can finally configure some SQL options I want to have in my template, basically because I want to have some general template, I will choose only Database Engine Services and Reporting Services – Native and for t he shared features directories I will leave default paths
- Now comes the next the check step. if .NET 3.5 Framework is installed, but I’ve done in the begining, so it’s ok 🙂
- Now comes the instance specific configuration, in my design, I will use a separate disk for the SQL instance – E: drive and the standard instance name will be MSSQL
- Next screen is just summary screen for the disk space requirements for the setup settings I have previously defined
- So now basically everything is ready just few more checks screens and summary screen and SQL image will be prepared
- So SQL template part is done
- Last step is to generalize Windows with sysprep, so I will open the command prompt and navigate to c:\Windows\System32\sysprep folder and run sysprep tool
- Now just the sysprep options and last “Ok” click.
So it’s done the Windows Sever 2012 R2 + SQL 2012 template is done, that’s pretty simple. In the further post I will show the steps to deploy SQL from previously prepared template.