Home
%3CLINGO-SUB%20id%3D%22lingo-sub-917599%22%20slang%3D%22en-US%22%3EBuild%20a%20SQL%20Cluster%20Lab%20Part%204%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-917599%22%20slang%3D%22en-US%22%3E%3CP%3E%3C!--%20wp%3Aparagraph%20--%3E%3C%2FP%3E%0A%3CP%3EYou%20are%20going%20to%20create%20a%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fsql%2Fsql-server%2Ffailover-clusters%2Fwindows%2Falways-on-failover-cluster-instances-sql-server%22%20target%3D%22_blank%22%20rel%3D%22noreferrer%20noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%20aria-label%3D%22SQL%20Server%20Failover%20Cluster%20Instance%20(opens%20in%20a%20new%20tab)%22%3ESQL%20Server%20Failover%20Cluster%20Instance%3C%2FA%3E%20in%20Part%204%20of%20our%20series%20on%20how%20to%20build%20a%20SQL%20Cluster%20Lab.%20The%20FCI%20will%20only%20be%20installed%20on%20Node1%20and%20Node2.%20FCIs%20require%20shared%20storage%20so%20you%20will%20make%20your%20domain%20controller%20an%20iSCSI%20target.%20Last%20you%20will%20create%20your%20FCI%20using%20the%20iSCSI%20drives%20you%20presented%20to%20the%20cluster.%20Here%20are%20links%20to%20the%20other%20articles%20in%20the%20series.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CDIV%20id%3D%22block-142a025d-5ca6-4d3d-8802-3fd8cec3b4c1%22%20class%3D%22wp-block%20editor-block-list__block%20block-editor-block-list__block%20is-hovered%20is-reusable%22%20tabindex%3D%220%22%20data-type%3D%22core%2Fblock%22%20aria-label%3D%22Block%3A%20Reusable%20Block%22%3E%0A%3CDIV%20class%3D%22editor-block-list__block-edit%20block-editor-block-list__block-edit%22%3E%0A%3CDIV%20data-block%3D%22142a025d-5ca6-4d3d-8802-3fd8cec3b4c1%22%3E%0A%3CDIV%20class%3D%22components-disabled%22%3E%0A%3CDIV%20class%3D%22block-library-list%20editor-rich-text%20block-editor-rich-text%22%3E%0A%3CDIV%3E%0A%3CDIV%3E%0A%3CDIV%20class%3D%22components-autocomplete%22%3E%0A%3CUL%3E%0A%3CLI%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2FPremier-Field-Engineering%2FBuild-a-SQL-Cluster-Lab-Part-1%2Fba-p%2F917572%22%20target%3D%22_blank%22%20rel%3D%22noopener%22%3EPart%201%20-%20Building%20the%20environment.%3C%2FA%3E%20Hyper-v%20VMs%2C%20Active%20Directory%2C%20DNS%2C%20and%20Routing%20and%20Remote%20Access%20Services%3C%2FLI%3E%0A%3CLI%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2FPremier-Field-Engineering%2FBuild-a-SQL-Cluster-Lab-Part-2%2Fba-p%2F917579%22%20target%3D%22_blank%22%20rel%3D%22noopener%22%3EPart%202%20-%20Windows%20Failover%20Clustering%3C%2FA%3E.%20Cluster%20validation%2C%20networks%2C%20and%20quorum%3C%2FLI%3E%0A%3CLI%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2FPremier-Field-Engineering%2FBuild-a-SQL-Cluster-Lab-Part-3%2Fba-p%2F981679%22%20target%3D%22_blank%22%20rel%3D%22noopener%22%3EPart%203%20-%20Availability%20Group%3C%2FA%3E.%20Dedicated%20network%20and%20AD%20permissions%3C%2FLI%3E%0A%3CLI%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2FPremier-Field-Engineering%2FBuild-a-SQL-Cluster-Lab-Part-4%2Fba-p%2F917599%22%20target%3D%22_blank%22%20rel%3D%22noopener%22%3EPart%204%20-%20Failover%20Cluster%20Instance%3C%2FA%3E.%20Creating%20shared%20storage%20using%20iSCSI%20and%20adding%20the%20storage%20to%20the%20cluster.%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3C%2FDIV%3E%0A%3C%2FDIV%3E%0A%3C%2FDIV%3E%0A%3C%2FDIV%3E%0A%3C%2FDIV%3E%0A%3C%2FDIV%3E%0A%3C%2FDIV%3E%0A%3C%2FDIV%3E%0A%3CDIV%20id%3D%22block-ca6e422c-a8fa-4baf-871d-a70875a34b83%22%20class%3D%22wp-block%20editor-block-list__block%20block-editor-block-list__block%22%20tabindex%3D%220%22%20data-type%3D%22core%2Fheading%22%20aria-label%3D%22Block%3A%20Heading%22%3E%0A%3CDIV%20class%3D%22editor-block-list__insertion-point%20block-editor-block-list__insertion-point%22%3E%0A%3CDIV%20class%3D%22editor-block-list__insertion-point-inserter%20block-editor-block-list__insertion-point-inserter%20is-visible%22%20tabindex%3D%22-1%22%3E%0A%3CDIV%20class%3D%22editor-inserter%20block-editor-inserter%22%3E%26nbsp%3B%3C%2FDIV%3E%0A%3C%2FDIV%3E%0A%3C%2FDIV%3E%0A%3C%2FDIV%3E%0A%3CP%3E%3C!--%20%2Fwp%3Aparagraph%20--%3E%20%3C!--%20wp%3Ablock%20%7B%22ref%22%3A2264%7D%20%2F--%3E%20%3C!--%20wp%3Aheading%20--%3E%3C%2FP%3E%0A%3CH2%20id%3D%22toc-hId-1846122358%22%20id%3D%22toc-hId-1849873877%22%3ENetwork%20Configuration%3C%2FH2%3E%0A%3CP%3E%3C!--%20%2Fwp%3Aheading%20--%3E%20%3C!--%20wp%3Aparagraph%20--%3E%3C%2FP%3E%0A%3CP%3EHere%20is%20the%20list%20of%20IP%20addresses%20from%20Part%201%20that%20you%20will%20need%20to%20configure%20the%20SQL%20Server%20FCI.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CTABLE%20class%3D%22wp-block-table%22%3E%0A%3CTBODY%3E%0A%3CTR%3E%0A%3CTD%20class%3D%22%22%3E%3CDIV%20class%3D%22editor-rich-text%20block-editor-rich-text%22%3E%0A%3CDIV%3E%0A%3CDIV%3E%0A%3CDIV%20class%3D%22components-autocomplete%22%3E%0A%3CDIV%20class%3D%22block-editor-rich-text__editable%20editor-rich-text__editable%20wp-block-table__cell-content%22%20role%3D%22textbox%22%20contenteditable%3D%22false%22%20aria-multiline%3D%22true%22%20aria-autocomplete%3D%22list%22%20data-is-placeholder-visible%3D%22false%22%3E%26nbsp%3B%3C%2FDIV%3E%0A%3C%2FDIV%3E%0A%3C%2FDIV%3E%0A%3C%2FDIV%3E%0A%3C%2FDIV%3E%0A%3C%2FTD%3E%0A%3CTD%20class%3D%22%22%3E%3CDIV%20class%3D%22editor-rich-text%20block-editor-rich-text%22%3E%0A%3CDIV%3E%0A%3CDIV%3E%0A%3CDIV%20class%3D%22components-autocomplete%22%3E%0A%3CDIV%20class%3D%22block-editor-rich-text__editable%20editor-rich-text__editable%20wp-block-table__cell-content%22%20role%3D%22textbox%22%20contenteditable%3D%22false%22%20aria-multiline%3D%22true%22%20aria-autocomplete%3D%22list%22%20data-is-placeholder-visible%3D%22false%22%3E%3CSTRONG%3EData%20Center%201%20IP%3C%2FSTRONG%3E%3C%2FDIV%3E%0A%3C%2FDIV%3E%0A%3C%2FDIV%3E%0A%3C%2FDIV%3E%0A%3C%2FDIV%3E%0A%3C%2FTD%3E%0A%3CTD%20class%3D%22%22%3E%3CDIV%20class%3D%22editor-rich-text%20block-editor-rich-text%22%3E%0A%3CDIV%3E%0A%3CDIV%3E%0A%3CDIV%20class%3D%22components-autocomplete%22%3E%0A%3CDIV%20class%3D%22block-editor-rich-text__editable%20editor-rich-text__editable%20wp-block-table__cell-content%22%20role%3D%22textbox%22%20contenteditable%3D%22false%22%20aria-multiline%3D%22true%22%20aria-autocomplete%3D%22list%22%20data-is-placeholder-visible%3D%22false%22%3E%3CSTRONG%3EData%20Center%202%20IP%3C%2FSTRONG%3E%3C%2FDIV%3E%0A%3C%2FDIV%3E%0A%3C%2FDIV%3E%0A%3C%2FDIV%3E%0A%3C%2FDIV%3E%0A%3C%2FTD%3E%0A%3C%2FTR%3E%0A%3CTR%3E%0A%3CTD%20class%3D%22%22%3E%3CDIV%20class%3D%22editor-rich-text%20block-editor-rich-text%22%3E%0A%3CDIV%3E%0A%3CDIV%3E%0A%3CDIV%20class%3D%22components-autocomplete%22%3E%0A%3CDIV%20class%3D%22block-editor-rich-text__editable%20editor-rich-text__editable%20wp-block-table__cell-content%22%20role%3D%22textbox%22%20contenteditable%3D%22false%22%20aria-multiline%3D%22true%22%20aria-autocomplete%3D%22list%22%20data-is-placeholder-visible%3D%22false%22%3ECluster%3C%2FDIV%3E%0A%3C%2FDIV%3E%0A%3C%2FDIV%3E%0A%3C%2FDIV%3E%0A%3C%2FDIV%3E%0A%3C%2FTD%3E%0A%3CTD%20class%3D%22%22%3E%3CDIV%20class%3D%22editor-rich-text%20block-editor-rich-text%22%3E%0A%3CDIV%3E%0A%3CDIV%3E%0A%3CDIV%20class%3D%22components-autocomplete%22%3E%0A%3CDIV%20class%3D%22block-editor-rich-text__editable%20editor-rich-text__editable%20wp-block-table__cell-content%22%20role%3D%22textbox%22%20contenteditable%3D%22false%22%20aria-multiline%3D%22true%22%20aria-autocomplete%3D%22list%22%20data-is-placeholder-visible%3D%22false%22%3E10.0.0.10%3C%2FDIV%3E%0A%3C%2FDIV%3E%0A%3C%2FDIV%3E%0A%3C%2FDIV%3E%0A%3C%2FDIV%3E%0A%3C%2FTD%3E%0A%3CTD%20class%3D%22%22%3E%3CDIV%20class%3D%22editor-rich-text%20block-editor-rich-text%22%3E%0A%3CDIV%3E%0A%3CDIV%3E%0A%3CDIV%20class%3D%22components-autocomplete%22%3E%0A%3CDIV%20class%3D%22block-editor-rich-text__editable%20editor-rich-text__editable%20wp-block-table__cell-content%22%20role%3D%22textbox%22%20contenteditable%3D%22false%22%20aria-multiline%3D%22true%22%20aria-autocomplete%3D%22list%22%20data-is-placeholder-visible%3D%22false%22%3E172.16.0.10%3C%2FDIV%3E%0A%3C%2FDIV%3E%0A%3C%2FDIV%3E%0A%3C%2FDIV%3E%0A%3C%2FDIV%3E%0A%3C%2FTD%3E%0A%3C%2FTR%3E%0A%3CTR%3E%0A%3CTD%20class%3D%22%22%3E%3CDIV%20class%3D%22editor-rich-text%20block-editor-rich-text%22%3E%0A%3CDIV%3E%0A%3CDIV%3E%0A%3CDIV%20class%3D%22components-autocomplete%22%3E%0A%3CDIV%20class%3D%22block-editor-rich-text__editable%20editor-rich-text__editable%20wp-block-table__cell-content%22%20role%3D%22textbox%22%20contenteditable%3D%22false%22%20aria-multiline%3D%22true%22%20aria-autocomplete%3D%22list%22%20data-is-placeholder-visible%3D%22false%22%3EAG%20Listener%3C%2FDIV%3E%0A%3C%2FDIV%3E%0A%3C%2FDIV%3E%0A%3C%2FDIV%3E%0A%3C%2FDIV%3E%0A%3C%2FTD%3E%0A%3CTD%20class%3D%22%22%3E%3CDIV%20class%3D%22editor-rich-text%20block-editor-rich-text%22%3E%0A%3CDIV%3E%0A%3CDIV%3E%0A%3CDIV%20class%3D%22components-autocomplete%22%3E%0A%3CDIV%20class%3D%22block-editor-rich-text__editable%20editor-rich-text__editable%20wp-block-table__cell-content%22%20role%3D%22textbox%22%20contenteditable%3D%22false%22%20aria-multiline%3D%22true%22%20aria-autocomplete%3D%22list%22%20data-is-placeholder-visible%3D%22false%22%3E10.0.0.11%3C%2FDIV%3E%0A%3C%2FDIV%3E%0A%3C%2FDIV%3E%0A%3C%2FDIV%3E%0A%3C%2FDIV%3E%0A%3C%2FTD%3E%0A%3CTD%20class%3D%22%22%3E%3CDIV%20class%3D%22editor-rich-text%20block-editor-rich-text%22%3E%0A%3CDIV%3E%0A%3CDIV%3E%0A%3CDIV%20class%3D%22components-autocomplete%22%3E%0A%3CDIV%20class%3D%22block-editor-rich-text__editable%20editor-rich-text__editable%20wp-block-table__cell-content%22%20role%3D%22textbox%22%20contenteditable%3D%22false%22%20aria-multiline%3D%22true%22%20aria-autocomplete%3D%22list%22%20data-is-placeholder-visible%3D%22false%22%3E172.16.0.11%3C%2FDIV%3E%0A%3C%2FDIV%3E%0A%3C%2FDIV%3E%0A%3C%2FDIV%3E%0A%3C%2FDIV%3E%0A%3C%2FTD%3E%0A%3C%2FTR%3E%0A%3CTR%3E%0A%3CTD%20class%3D%22%22%3E%3CDIV%20class%3D%22editor-rich-text%20block-editor-rich-text%22%3E%0A%3CDIV%3E%0A%3CDIV%3E%0A%3CDIV%20class%3D%22components-autocomplete%22%3E%0A%3CDIV%20class%3D%22block-editor-rich-text__editable%20editor-rich-text__editable%20wp-block-table__cell-content%22%20role%3D%22textbox%22%20contenteditable%3D%22false%22%20aria-multiline%3D%22true%22%20aria-autocomplete%3D%22list%22%20data-is-placeholder-visible%3D%22false%22%3EFCI%3C%2FDIV%3E%0A%3C%2FDIV%3E%0A%3C%2FDIV%3E%0A%3C%2FDIV%3E%0A%3C%2FDIV%3E%0A%3C%2FTD%3E%0A%3CTD%20class%3D%22%22%3E%3CDIV%20class%3D%22editor-rich-text%20block-editor-rich-text%22%3E%0A%3CDIV%3E%0A%3CDIV%3E%0A%3CDIV%20class%3D%22components-autocomplete%22%3E%0A%3CDIV%20class%3D%22block-editor-rich-text__editable%20editor-rich-text__editable%20wp-block-table__cell-content%22%20role%3D%22textbox%22%20contenteditable%3D%22false%22%20aria-multiline%3D%22true%22%20aria-autocomplete%3D%22list%22%20data-is-placeholder-visible%3D%22false%22%3E10.0.0.15%3C%2FDIV%3E%0A%3C%2FDIV%3E%0A%3C%2FDIV%3E%0A%3C%2FDIV%3E%0A%3C%2FDIV%3E%0A%3C%2FTD%3E%0A%3CTD%20class%3D%22%22%3E%3CDIV%20class%3D%22editor-rich-text%20block-editor-rich-text%22%3E%0A%3CDIV%3E%0A%3CDIV%3E%0A%3CDIV%20class%3D%22components-autocomplete%22%3E%0A%3CDIV%20class%3D%22block-editor-rich-text__editable%20editor-rich-text__editable%20wp-block-table__cell-content%22%20role%3D%22textbox%22%20contenteditable%3D%22false%22%20aria-multiline%3D%22true%22%20aria-autocomplete%3D%22list%22%20data-is-placeholder-visible%3D%22false%22%3EN%2FA%3C%2FDIV%3E%0A%3C%2FDIV%3E%0A%3C%2FDIV%3E%0A%3C%2FDIV%3E%0A%3C%2FDIV%3E%0A%3C%2FTD%3E%0A%3C%2FTR%3E%0A%3C%2FTBODY%3E%0A%3C%2FTABLE%3E%0A%3CP%3E%3C!--%20%2Fwp%3Aparagraph%20--%3E%20%3C!--%20wp%3Ablock%20%7B%22ref%22%3A2261%7D%20%2F--%3E%20%3C!--%20wp%3Aheading%20--%3E%3C%2FP%3E%0A%3CH2%20id%3D%22toc-hId--706034603%22%20id%3D%22toc-hId--702283084%22%3E%26nbsp%3B%3C%2FH2%3E%0A%3CH2%20id%3D%22toc-hId-1036775732%22%20id%3D%22toc-hId-1040527251%22%3EArchitecture%3C%2FH2%3E%0A%3CP%3E%3C!--%20%2Fwp%3Aheading%20--%3E%20%3C!--%20wp%3Aparagraph%20--%3E%3C%2FP%3E%0A%3CP%3EAs%20a%20refresher%2C%20here%20is%20the%20diagram%20of%20the%20lab%20you%20are%20building.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F138175i3543A71F7D31F70F%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Lab%20Architecture.png%22%20title%3D%22Lab%20Architecture.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3C!--%20%2Fwp%3Aparagraph%20--%3E%20%3C!--%20wp%3Aimage%20%7B%22id%22%3A2274%2C%22linkDestination%22%3A%22media%22%7D%20--%3E%3C%2FP%3E%0A%3CP%3E%3C!--%20%2Fwp%3Aimage%20--%3E%20%3C!--%20wp%3Aheading%20--%3E%3C%2FP%3E%0A%3CH2%20id%3D%22toc-hId--1515381229%22%20id%3D%22toc-hId--1511629710%22%3EBuild%20Failover%20Cluster%20Instance%20Video%3C%2FH2%3E%0A%3CP%3E%3C!--%20%2Fwp%3Aheading%20--%3E%20%3C!--%20wp%3Acore-embed%2Fyoutube%20%7B%22url%22%3A%22https%3A%2F%2Fyoutu.be%2FMQSikCe7Vm8%22%2C%22type%22%3A%22video%22%2C%22providerNameSlug%22%3A%22youtube%22%2C%22className%22%3A%22wp-embed-aspect-16-9%20wp-has-aspect-ratio%22%7D%20--%3E%3C%2FP%3E%0A%3CFIGURE%20class%3D%22wp-block-embed-youtube%20wp-block-embed%20is-type-video%20is-provider-youtube%20wp-embed-aspect-16-9%20wp-has-aspect-ratio%22%3E%0A%3CDIV%20class%3D%22wp-block-embed__wrapper%22%3E%3CDIV%20class%3D%22video-embed-center%20video-embed%22%3E%3CIFRAME%20class%3D%22embedly-embed%22%20src%3D%22https%3A%2F%2Fcdn.embedly.com%2Fwidgets%2Fmedia.html%3Fsrc%3Dhttps%253A%252F%252Fwww.youtube.com%252Fembed%252FMQSikCe7Vm8%253Ffeature%253Doembed%26amp%3Burl%3Dhttps%253A%252F%252Fwww.youtube.com%252Fwatch%253Fv%253DMQSikCe7Vm8%26amp%3Bimage%3Dhttps%253A%252F%252Fi.ytimg.com%252Fvi%252FMQSikCe7Vm8%252Fhqdefault.jpg%26amp%3Bkey%3Db0d40caa4f094c68be7c29880b16f56e%26amp%3Btype%3Dtext%252Fhtml%26amp%3Bschema%3Dyoutube%22%20width%3D%22600%22%20height%3D%22337%22%20scrolling%3D%22no%22%20frameborder%3D%220%22%20allow%3D%22autoplay%3B%20fullscreen%22%20allowfullscreen%3D%22true%22%20title%3D%22Video%22%3E%3C%2FIFRAME%3E%3C%2FDIV%3E%3C%2FDIV%3E%0A%3C%2FFIGURE%3E%0A%3CP%3E%3C!--%20%2Fwp%3Acore-embed%2Fyoutube%20--%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-917599%22%20slang%3D%22en-US%22%3E%3CP%3EIn%20Part%204%2C%20you%20are%20going%20to%20build%20a%20SQL%20Server%20Failover%20Cluster%20Instance.%20You%20also%20create%20shared%20storage%20using%20iSCSI%20target%20on%20the%20Domain%20Controller.%3C%2FP%3E%3C%2FLINGO-TEASER%3E%3CLINGO-LABS%20id%3D%22lingo-labs-917599%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ERyanAdams%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Microsoft

You are going to create a SQL Server Failover Cluster Instance in Part 4 of our series on how to build a SQL Cluster Lab. The FCI will only be installed on Node1 and Node2. FCIs require shared storage so you will make your domain controller an iSCSI target. Last you will create your FCI using the iSCSI drives you presented to the cluster. Here are links to the other articles in the series.

 

 

Network Configuration

Here is the list of IP addresses from Part 1 that you will need to configure the SQL Server FCI.

 

 
Data Center 1 IP
Data Center 2 IP
Cluster
10.0.0.10
172.16.0.10
AG Listener
10.0.0.11
172.16.0.11
FCI
10.0.0.15
N/A

 

Architecture

As a refresher, here is the diagram of the lab you are building.

 

Lab Architecture.png

Build Failover Cluster Instance Video