Home

High Availability configuration in windows server 2016

%3CLINGO-SUB%20id%3D%22lingo-sub-911629%22%20slang%3D%22en-US%22%3EHigh%20Availability%20configuration%20in%20windows%20server%202016%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-911629%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20Team%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20been%20having%20an%20issue%20configuring%20HA%20in%20windows%20server%202016.%3C%2FP%3E%3CUL%3E%3CLI%3EI%20have%20the%20two%20servers%20configured%3C%2FLI%3E%3CLI%3EThe%20SQL%20Express%20is%20installed%20on%20both%20servers%20as%20a%20requirement%3C%2FLI%3E%3C%2FUL%3E%3CP%3EBut%20there%20was%20no%20success%20in%20configuring%20this.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20anyone%20could%20help%20me%20on%20how%20to%20set%20up%20high%20availability%20%22HA%22%20in%20windows%20server%202016.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERegards%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-912421%22%20slang%3D%22en-US%22%3ERe%3A%20High%20Availability%20configuration%20in%20windows%20server%202016%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-912421%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F395204%22%20target%3D%22_blank%22%3E%40tonnybabs%3C%2FA%3E%26nbsp%3B-%20Which%20service%20(or%20app)%20are%20you%20trying%20to%20make%20HA%3F%20Are%20you%20trying%20to%20make%20SQL%20HA%3F%20I%20cannot%20tell%20by%20your%20question.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAs%20far%20as%20building%20a%20base%20cluster%20with%20Windows%202016%2C%20this%20documentation%20may%20assist%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CH1%20id%3D%22toc-hId-2042457885%22%20id%3D%22toc-hId-2042457885%22%20id%3D%22toc-hId-2042457885%22%20id%3D%22toc-hId-2042457885%22%20id%3D%22toc-hId-2042457885%22%3ECreate%20a%20failover%20cluster%3C%2FH1%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fwindows-server%2Ffailover-clustering%2Fcreate-failover-cluster%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fwindows-server%2Ffailover-clustering%2Fcreate-failover-cluster%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-912671%22%20slang%3D%22en-US%22%3ERe%3A%20High%20Availability%20configuration%20in%20windows%20server%202016%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-912671%22%20slang%3D%22en-US%22%3E%3CP%3EHigh%20availability%20is%20not%20a%20feature%20of%20SQL%20Express%20edition.%3C%2FP%3E%0A%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fsql%2Fsql-server%2Feditions-and-components-of-sql-server-2017%3Fview%3Dsql-server-ver15%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3E%3CFONT%20style%3D%22background-color%3A%20%23ffffff%3B%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fsql%2Fsql-server%2Feditions-and-components-of-sql-server-2017%3Fview%3Dsql-server-ver15%3C%2FFONT%3E%3C%2FA%3E%3C%2FP%3E%0A%3CP%3E%3CFONT%20style%3D%22background-color%3A%20%23ffffff%3B%22%3E%26nbsp%3B%26nbsp%3B%3C%2FFONT%3E%3C%2FP%3E%0A%3CP%3E%3CFONT%20style%3D%22background-color%3A%20%23ffffff%3B%22%3EYou'll%20also%20find%20more%20SQL%20HA%20experts%20over%20here%20in%20dedicated%20forum.%3C%2FFONT%3E%3C%2FP%3E%0A%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsocial.msdn.microsoft.com%2FForums%2Fsqlserver%2Fen-US%2Fhome%3Fforum%3Dsqldisasterrecovery%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3E%3CFONT%20style%3D%22background-color%3A%20%23ffffff%3B%22%3Ehttps%3A%2F%2Fsocial.msdn.microsoft.com%2FForums%2Fsqlserver%2Fen-US%2Fhome%3Fforum%3Dsqldisasterrecovery%3C%2FFONT%3E%3C%2FA%3E%3C%2FP%3E%0A%3CP%3E%3CFONT%20style%3D%22background-color%3A%20%23ffffff%3B%22%3E%26nbsp%3B%3C%2FFONT%3E%3C%2FP%3E%0A%3CP%3E%3CFONT%20style%3D%22background-color%3A%20%23ffffff%3B%22%3E%26nbsp%3B%3C%2FFONT%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-915470%22%20slang%3D%22en-US%22%3ERe%3A%20High%20Availability%20configuration%20in%20windows%20server%202016%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-915470%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F395204%22%20target%3D%22_blank%22%3E%40tonnybabs%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%2C%3CBR%20%2F%3EThis%20is%20one%20of%20the%20%3CFONT%20size%3D%224%22%3EBest%20guides%3C%2FFONT%3E%20out%20there%20to%20help%20you%20set%20up%20your%20Highly%20Available%20Fail%20over%20Cluster%20in%20Windows%20Server%202016%20and%20since%20you%20haven't%20mentioned%20which%20services%20you%20wanna%20use%20on%20it%2C%20here%20is%20for%20Hyper-V%20VM%2C%3C%2FP%3E%3CP%3Emost%20of%20it%20is%20similar%20for%20all%20services%20so%20it%20should%20give%20you%20an%20overall%20idea%20if%20you're%20new%20to%20this%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3Ddd2_ivhnG54%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3Ddd2_ivhnG54%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
tonnybabs
Occasional Contributor

Hello Team,

 

I have been having an issue configuring HA in windows server 2016.

  • I have the two servers configured
  • The SQL Express is installed on both servers as a requirement

But there was no success in configuring this.

 

If anyone could help me on how to set up high availability "HA" in windows server 2016.

 

Regards

 

5 Replies

@tonnybabs - Which service (or app) are you trying to make HA? Are you trying to make SQL HA? I cannot tell by your question.

 

As far as building a base cluster with Windows 2016, this documentation may assist:

 

Create a failover cluster

https://docs.microsoft.com/en-us/windows-server/failover-clustering/create-failover-cluster

 

 

High availability is not a feature of SQL Express edition.

https://docs.microsoft.com/en-us/sql/sql-server/editions-and-components-of-sql-server-2017?view=sql-...

  

You'll also find more SQL HA experts over here in dedicated forum.

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/home?forum=sqldisasterrecovery

 

 

 

 

@tonnybabs 

 

Hi,
This is one of the Best guides out there to help you set up your Highly Available Fail over Cluster in Windows Server 2016 and since you haven't mentioned which services you wanna use on it, here is for Hyper-V VM,

most of it is similar for all services so it should give you an overall idea if you're new to this

 

https://www.youtube.com/watch?v=dd2_ivhnG54

 

This video is a complete tutorial on how to build a Hyper-V failover cluster on Windows Server 2016 from 3 fresh Windows Server 2016 machines. The topics covered include: Active Directory creation and join, lab network setup, iSCSI shared storage, failover cluster and Hyper-V. All configuration ...

@Edward Dake 

 

It is on Windows' level not on SQL. I actually set up two servers and I want both to be on high availability. 

Thank you.

Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies