Windows Server 2012 R2 with SQL Server 2014 Cluster installation in less than 15 minutes #winserv #Rocks #movie   21 comments

Just for the fun I recorded a movie on the installation of Windows Server 2012 R2 . I thought just a quick recording and done but as it turns out it took longer than I expected, I made a typo in the script or clicked the wrong script or forgot to clean out my netbios name. then you gona build failsafe items in the scripts and they will be shown as errors because some items are already be set and can’t set twice.

The basic Idea was record a quick movie of an unattended installation of a SQL cluster in a few minutes is this possible yes it cab be done in les than 15 minutes. installation of the OS , Cluster with full Storage validation and a two node SQL cluster based on normal disk and a two node cluster based on CSV.

Eh in 15 minutes two full SQL nodes. just for fun.

when I was building this lab and thought recording in one piece is no fun I can never use the items in one piece and the movie size is bigger.

So I created every step in a single movie file, with sound and created one big movie with some speeding steps in it.

First the Windows Installation movie. ( did you know the Cluster validation process with full Storage testing took longer than the Complete installation from OS and SQL server Winking smile 

So the OS installation the Windows version choice can be avoided by pre-staging  the VM’s and I like to choose my disk size not very disk in my OS is the same. nor do I set a name ,IP and domain join the VM in one pass. I like to be flexible and do this step by step. and for demo’s is is nicer to show.

Watch this new video I made 


Windows Server 2012 R2 unattended SQL Server 2014 Cluster installation On Clustered Shared Volumes


The SQL installation on CSV and adding the node to the normal SQL on disk took 7 minutes.  The installation on the Disk was about 4 minutes slower.

Who said that clustering was hard Winking smile

The scripts what I used are all available I already posted this on my blog. See my blog post on the SQL Server 2014 installation.

21 responses to “Windows Server 2012 R2 with SQL Server 2014 Cluster installation in less than 15 minutes #winserv #Rocks #movie

Subscribe to comments with RSS.

  1. Reblogged this on The Windows Server FCI Blog and commented:

    SQL Server 2014 now Generally Available Build your Cluster #sql

  2. Unquestionably imagine that that you stated. Your favourite justification appeared to be on the
    web the simplest thing to remember of. I say to you, I certainly get
    annoyed even as other people consider worries that they just don’t know about.
    You controlled to hit the nail upon the top
    as well as defined out the whole thing with
    no need side-effects , people could take a signal. Will probably be back to get more.

  3. Have you ever considered about adding a little bit
    more than just your articles? I mean, what you say is valuable and everything.
    Nevertheless imagine if you added some great graphics or videos to
    give your posts more, “pop”! Your content is excellent but with pics and clips,
    this website could definitely be one of the most beneficial in its niche.

    Amazing blog!

  4. Hi,

    I have a query/clarification, request your help in understanding know-how better.

    I have already installed 2 node SQL server 2012 failover cluster on windows cluster. The requirement is to install another 2 node SQL server 2012 cluster on the same machines. It would be great if someone can share the exact steps to be carried out.

  5. Robert – Would it be possible to obtain copies of your scripts used in this video? I have looked through your blog without any luck of locating them.
    In awe of your work!

    Thank you!

  6. Get the ini files here
    here is the link from the SQL setup file and I will add the other scripts there also

    • Hi Robert, Thanks for this great blog! Unfortunately the link to the ini files shows a ‘This item might not exist or is no longer available’ on

    • Robert,

      Thank you for the quick reply. I’m getting the following when clicking the link…

      This item might not exist or is no longer available
      This item might have been deleted, expired, or you might not have permission to view it. Contact the owner of this item for more information

      Patrick Bemis
  7. Pingback: AlwaysOn Failover Cluster Instances SQL Server 2014 in #part2 #azure #winserv #SQL #msteched | The Windows Server FCI Blog

  8. Pingback: AlwaysOn Failover Cluster Instances SQL Server 2014 in #part2 #azure #winserv #SQL #msteched - System Center Failover Clustering

  9. scripts can be found here

  10. Pingback: Getting started with Windows Volume Replication (Storage Replica) to Azure Configuration does it Work ? #winserv #SR #Azure #WVR #MVPBuzz | The Windows Server FCI Blog

  11. Pingback: Build a G5 G-Series #azure VM SQL Server 2014 Cluster With shared cloud Storage #SQL #Winserv | The Windows Server FCI Blog

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

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

  • Twitter

  • RSS Azure and Microsoft Windows Server Blog

  • <span>%d</span> bloggers like this: