Windows Server 2016 With Clustered SQL Server 2016 Instance #winserv #SQL #WS2016 #SQL2016

Now that Windows Server 2016 is there and SQL server 2016. you can build a default cluster with SQL but that is no fun. Building a SQL Cluster on Storage Spaces Direct or putting the Databases on storage replication.  or building a hybrid SQL cluster with Azure.

In my blog there are plenty off samples on how to build this. This blog is a easy step by step on hoe to create a cluster with the 2016 products.  ( basically the same as 2008,2012R2 )

Get your Windows server 2016 here

What’s new in Windows Server 2016 ?

the Cluster is easy I use 3 lines of PowerShell to create this. needless to say the .net 3.5 is needed for SQL!

Windows Server 2016 is there and SQL server 2016

Installing the Cluster feature you will need to reboot this node.
install-WindowsFeature "Failover-Clustering","RSAT-Clustering" -IncludeAllSubFeature -ComputerName "mvpsql16-1.mvp.local","mvpsql16-1.mvp.local"
Test-Cluster -Node "mvpsql16-1.mvp.local","mvpsql16-1.mvp.local"
New-Cluster -Name Techdays01 -Node "mvpsql16-1.mvp.local","mvpsql16-1.mvp.local" -NoStorage -StaticAddress ""

The Cluster is in place and yes you could do create a new failover cluster but that is to easy. command line is way faster with the advanced config.

Windows Server 2016 is there and SQL server 2016


Let’s pick the two steps installation in the advanced menu. cluster prep and cluster completion.


first step is advanced cluster preparation. when installing from command line you will need a ini file during the GUI setup you can save this ini file and use this for later or you can use an older file non 2016 if you just want to setup the DB.

Windows Server 2016 is there and SQL server 2016

If you are using named instances you can see this error if you are not using the right names


SQL named instance Requirements  :


Step 1


WHen using the Command line with the INI file you can do this :

Remember to change the ini file and set the ignore to the UIMODE="Normal"



In just a few minutes you have completed the whole setup.  ( 5 minute Setup Windows Server 2012R2


Step 1 is done still there is nothing to see in the Cluster but the first part of SQL install is done.




Creating the Cluster with the advanced Cluster completion.


Important that you did run the cluster validation. else the setup will fail.



Using the named instance and using the Created ini file in step 2 if you haven’t had this file.



image image

Done in just a few minutes and ready for the next Cluster rollout using the unattended files just change the names and IP and or locations in the INI files and you are ready to go.



Done for Part 1 the cluster basics.

Happy clustering

Robert Smit


Author: Robert Smit [MVP]

Robert Smit is Senior Technical Evangelist and is a current Microsoft MVP in Clustering as of 2009. Robert has over 20 years experience in IT with experience in the educational, health-care and finance industries. Robert’s past IT experience in the trenches of IT gives him the knowledge and insight that allows him to communicate effectively with IT professionals who are trying to address real concerns around business continuity, disaster recovery and regulatory compliance issues. Robert holds the following certifications: MCT - Microsoft Certified Trainer, MCTS - Windows Server Virtualization, MCSE, MCSA and MCPS. He is an active participant in the Microsoft newsgroup community and is currently focused on Hyper-V, Failover Clustering, SQL Server, Azure and all things related to Cloud Computing and Infrastructure Optimalization. Follow Robert on Twitter @ClusterMVP Or follow his blog Linkedin Profile Http:// Robert is also capable of transferring his knowledge to others which is a rare feature in the field of IT. He makes a point of not only solving issues but also of giving on the job training of his colleagues. A customer says " Robert has been a big influence on our technical staff and I have to come to know him as a brilliant specialist concerning Microsoft Products. He was Capable with his in-depth knowledge of Microsoft products to troubleshoot problems and develop our infrastructure to a higher level. I would certainly hire him again in the future. " Details of the Recommendation: "I have been coordinating with Robert implementing a very complex system. Although he was primarily a Microsoft infrastructure specialist; he was able to understand and debug .Net based complext Windows applications and websites. His input to improve performance of applications proved very helpful for the success of our project

Leave a Reply

Please log in using one of these methods to post your comment: Logo

You are commenting using your 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.

%d bloggers like this: