HOWTO : Create a Windows Server + SQL Server template

0 Flares 0 Flares ×

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

  1. 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”
  2. Next step is just clicking “Ok” on the checks screen
  3. 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 🙂
  4. On the Product Updates window, I’m getting error, because my VM is not connected to internet
  5. On another checks screen, I’m getting one warning because I don’t have internet connection
  6. 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
  7. 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 🙂
  8. 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
  9. Next screen is just summary screen for the disk space requirements for the setup settings I have previously defined
  10. So now basically everything is ready just few more checks screens and summary screen and SQL image will be prepared

  11. So SQL template part is done
  12. 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
  13. 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.

0 Flares LinkedIn 0 Google+ 0 Facebook 0 Twitter 0 0 Flares ×

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.