{"id":6666,"date":"2019-03-15T12:35:54","date_gmt":"2019-03-15T12:35:54","guid":{"rendered":"https:\/\/ittutorial.org\/?p=6666"},"modified":"2019-11-28T06:59:57","modified_gmt":"2019-11-28T06:59:57","slug":"sql-server-failover-cluster-installation-3","status":"publish","type":"post","link":"https:\/\/ittutorial.org\/sql-server-failover-cluster-installation-3\/","title":{"rendered":"SQL Server Failover Cluster Installation -3"},"content":{"rendered":"<p>Hi,<\/p>\n<p>I will continue to tell\u00a0SQL Server Failover Cluster Installation in this post.<\/p>\n<p><a href=\"http:\/\/salihdeveci.files.wordpress.com\/2013\/04\/activepassivecluster.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3126\" src=\"http:\/\/salihdeveci.files.wordpress.com\/2013\/04\/activepassivecluster.jpg\" alt=\"ActivePassiveCluster\" width=\"467\" height=\"559\" srcset=\"https:\/\/ittutorial.org\/wp-content\/uploads\/2013\/04\/activepassivecluster.jpg 467w, https:\/\/ittutorial.org\/wp-content\/uploads\/2013\/04\/activepassivecluster-251x300.jpg 251w\" sizes=\"auto, (max-width: 467px) 100vw, 467px\" \/><\/a><\/p>\n<p><!--more--><\/p>\n\n<p>&nbsp;<\/p>\n<p>Read previous article with following link.<\/p>\n<blockquote class=\"wp-embedded-content\" data-secret=\"cCufVFTwA8\"><p><a href=\"https:\/\/ittutorial.org\/sql-server-failover-cluster-installation-2\/\">SQL Server Failover Cluster Installation -2<\/a><\/p><\/blockquote>\n<p><iframe loading=\"lazy\" class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; clip: rect(1px, 1px, 1px, 1px);\" title=\"&#8220;SQL Server Failover Cluster Installation -2&#8221; &#8212; IT Tutorial\" src=\"https:\/\/ittutorial.org\/sql-server-failover-cluster-installation-2\/embed\/#?secret=TOVg8DCR1v#?secret=cCufVFTwA8\" data-secret=\"cCufVFTwA8\" width=\"600\" height=\"338\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe><\/p>\n<p>&nbsp;<\/p>\n<p>You should added to the node according to the criticality of the application in the Failover Cluster architecture . In SQL Server 2008 Enterprise R2, up to a maximum of 16 nodes can be reached, this number is up to 64 in SQL Server 2012. Again, the number of nodes to be added depends entirely on the criticality of the application.<\/p>\n<p>As a result, every node added means a server and the resources allocated to it. The cost increases as the number of Node increases, but High Availability increases in the face because the presence of the alternate node of each server will increase our high availability of service .<\/p>\n<p>In the previous article, we have installed SQL Server Cluster on one of the two separate servers that have Windows Cluster installation. Now we are adding the same Cluster a node. The steps will be as follows.<\/p>\n\n<p>&nbsp;<\/p>\n<p>1. In setup files, we run setup.exe as below on Second server.<\/p>\n<p><a href=\"http:\/\/salihdeveci.files.wordpress.com\/2013\/04\/13.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3112\" src=\"http:\/\/salihdeveci.files.wordpress.com\/2013\/04\/13.png\" alt=\"1\" width=\"614\" height=\"359\" srcset=\"https:\/\/ittutorial.org\/wp-content\/uploads\/2013\/04\/13.png 1018w, https:\/\/ittutorial.org\/wp-content\/uploads\/2013\/04\/13-300x176.png 300w, https:\/\/ittutorial.org\/wp-content\/uploads\/2013\/04\/13-768x450.png 768w\" sizes=\"auto, (max-width: 614px) 100vw, 614px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><a href=\"http:\/\/salihdeveci.files.wordpress.com\/2013\/04\/210.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3113\" src=\"http:\/\/salihdeveci.files.wordpress.com\/2013\/04\/210.png\" alt=\"2\" width=\"614\" height=\"457\" srcset=\"https:\/\/ittutorial.org\/wp-content\/uploads\/2013\/04\/210.png 798w, https:\/\/ittutorial.org\/wp-content\/uploads\/2013\/04\/210-300x224.png 300w, https:\/\/ittutorial.org\/wp-content\/uploads\/2013\/04\/210-768x573.png 768w\" sizes=\"auto, (max-width: 614px) 100vw, 614px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>2. In this step, click OK button to go on.<\/p>\n<p><a href=\"http:\/\/salihdeveci.files.wordpress.com\/2013\/04\/32.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3114\" src=\"http:\/\/salihdeveci.files.wordpress.com\/2013\/04\/32.png\" alt=\"3\" width=\"614\" height=\"453\" srcset=\"https:\/\/ittutorial.org\/wp-content\/uploads\/2013\/04\/32.png 820w, https:\/\/ittutorial.org\/wp-content\/uploads\/2013\/04\/32-300x222.png 300w, https:\/\/ittutorial.org\/wp-content\/uploads\/2013\/04\/32-768x568.png 768w\" sizes=\"auto, (max-width: 614px) 100vw, 614px\" \/><\/a><\/p>\n\n<p>3. In this step, enter Product Key and click Next button.<\/p>\n<p><a href=\"http:\/\/salihdeveci.files.wordpress.com\/2013\/04\/41.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3115\" src=\"http:\/\/salihdeveci.files.wordpress.com\/2013\/04\/41.png\" alt=\"4\" width=\"614\" height=\"460\" srcset=\"https:\/\/ittutorial.org\/wp-content\/uploads\/2013\/04\/41.png 814w, https:\/\/ittutorial.org\/wp-content\/uploads\/2013\/04\/41-300x225.png 300w, https:\/\/ittutorial.org\/wp-content\/uploads\/2013\/04\/41-768x576.png 768w\" sizes=\"auto, (max-width: 614px) 100vw, 614px\" \/><\/a><\/p>\n<p>4. In this step, click OK button to go on.<\/p>\n<p><a href=\"http:\/\/salihdeveci.files.wordpress.com\/2013\/04\/51.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3116\" src=\"http:\/\/salihdeveci.files.wordpress.com\/2013\/04\/51.png\" alt=\"5\" width=\"614\" height=\"456\" srcset=\"https:\/\/ittutorial.org\/wp-content\/uploads\/2013\/04\/51.png 817w, https:\/\/ittutorial.org\/wp-content\/uploads\/2013\/04\/51-300x223.png 300w, https:\/\/ittutorial.org\/wp-content\/uploads\/2013\/04\/51-768x571.png 768w\" sizes=\"auto, (max-width: 614px) 100vw, 614px\" \/><\/a><\/p>\n<p>4. In this step, click Install button to start installation.<a href=\"http:\/\/salihdeveci.files.wordpress.com\/2013\/04\/6.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3117\" src=\"http:\/\/salihdeveci.files.wordpress.com\/2013\/04\/6.png\" alt=\"6\" width=\"614\" height=\"455\" srcset=\"https:\/\/ittutorial.org\/wp-content\/uploads\/2013\/04\/6.png 814w, https:\/\/ittutorial.org\/wp-content\/uploads\/2013\/04\/6-300x223.png 300w, https:\/\/ittutorial.org\/wp-content\/uploads\/2013\/04\/6-768x570.png 768w\" sizes=\"auto, (max-width: 614px) 100vw, 614px\" \/><\/a><\/p>\n<p>5. In this step, the necessary parameters of system and Networks are checked on Windows Cluster as shown in the picture below. If there is a problem, it will not continue or installation will be problematic. As seen below, there is no problem except for some trivial warnings because there is no problem in our establishment. Click Next button and continue.<\/p>\n<p>&nbsp;<\/p>\n\n<p><a href=\"http:\/\/salihdeveci.files.wordpress.com\/2013\/04\/71.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3118\" src=\"http:\/\/salihdeveci.files.wordpress.com\/2013\/04\/71.png\" alt=\"7\" width=\"614\" height=\"461\" srcset=\"https:\/\/ittutorial.org\/wp-content\/uploads\/2013\/04\/71.png 812w, https:\/\/ittutorial.org\/wp-content\/uploads\/2013\/04\/71-300x225.png 300w, https:\/\/ittutorial.org\/wp-content\/uploads\/2013\/04\/71-768x577.png 768w\" sizes=\"auto, (max-width: 614px) 100vw, 614px\" \/><\/a><\/p>\n<p>6. In this step, the Node Configuration of the Cluster is performed. Instance Name, Node Name and Cluster Network Name values are entered. We can give the active and passive Node the name we want, but we have to enter the Cluster Name which is preset of the Cluster Name. Click Next and continue.<\/p>\n<p><a href=\"http:\/\/salihdeveci.files.wordpress.com\/2013\/04\/82.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3119\" src=\"http:\/\/salihdeveci.files.wordpress.com\/2013\/04\/82.png\" alt=\"8\" width=\"614\" height=\"460\" srcset=\"https:\/\/ittutorial.org\/wp-content\/uploads\/2013\/04\/82.png 818w, https:\/\/ittutorial.org\/wp-content\/uploads\/2013\/04\/82-300x225.png 300w, https:\/\/ittutorial.org\/wp-content\/uploads\/2013\/04\/82-768x576.png 768w\" sizes=\"auto, (max-width: 614px) 100vw, 614px\" \/><\/a><\/p>\n<p>7. In this step, Account of Instance will be the same as the previous Node.<\/p>\n<p><a href=\"http:\/\/salihdeveci.files.wordpress.com\/2013\/04\/9.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3120\" src=\"http:\/\/salihdeveci.files.wordpress.com\/2013\/04\/9.png\" alt=\"9\" width=\"614\" height=\"460\" srcset=\"https:\/\/ittutorial.org\/wp-content\/uploads\/2013\/04\/9.png 816w, https:\/\/ittutorial.org\/wp-content\/uploads\/2013\/04\/9-300x225.png 300w, https:\/\/ittutorial.org\/wp-content\/uploads\/2013\/04\/9-768x576.png 768w\" sizes=\"auto, (max-width: 614px) 100vw, 614px\" \/><\/a><\/p>\n<p>8. In this step, click Next button to go on.<\/p>\n<p><a href=\"http:\/\/salihdeveci.files.wordpress.com\/2013\/04\/101.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3121\" src=\"http:\/\/salihdeveci.files.wordpress.com\/2013\/04\/101.png\" alt=\"10\" width=\"614\" height=\"298\" srcset=\"https:\/\/ittutorial.org\/wp-content\/uploads\/2013\/04\/101.png 1254w, https:\/\/ittutorial.org\/wp-content\/uploads\/2013\/04\/101-300x146.png 300w, https:\/\/ittutorial.org\/wp-content\/uploads\/2013\/04\/101-768x374.png 768w, https:\/\/ittutorial.org\/wp-content\/uploads\/2013\/04\/101-1024x498.png 1024w\" sizes=\"auto, (max-width: 614px) 100vw, 614px\" \/><\/a><\/p>\n\n<p>9. In this step, click Next button to go on.<\/p>\n<p><a href=\"http:\/\/salihdeveci.files.wordpress.com\/2013\/04\/111.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3122\" src=\"http:\/\/salihdeveci.files.wordpress.com\/2013\/04\/111.png\" alt=\"11\" width=\"614\" height=\"297\" srcset=\"https:\/\/ittutorial.org\/wp-content\/uploads\/2013\/04\/111.png 1269w, https:\/\/ittutorial.org\/wp-content\/uploads\/2013\/04\/111-300x145.png 300w, https:\/\/ittutorial.org\/wp-content\/uploads\/2013\/04\/111-768x372.png 768w, https:\/\/ittutorial.org\/wp-content\/uploads\/2013\/04\/111-1024x496.png 1024w\" sizes=\"auto, (max-width: 614px) 100vw, 614px\" \/><\/a><\/p>\n<p>10. In this step, click Install button to go on.<\/p>\n<p><a href=\"http:\/\/salihdeveci.files.wordpress.com\/2013\/04\/121.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3123\" src=\"http:\/\/salihdeveci.files.wordpress.com\/2013\/04\/121.png\" alt=\"12\" width=\"614\" height=\"296\" srcset=\"https:\/\/ittutorial.org\/wp-content\/uploads\/2013\/04\/121.png 1265w, https:\/\/ittutorial.org\/wp-content\/uploads\/2013\/04\/121-300x145.png 300w, https:\/\/ittutorial.org\/wp-content\/uploads\/2013\/04\/121-768x371.png 768w, https:\/\/ittutorial.org\/wp-content\/uploads\/2013\/04\/121-1024x495.png 1024w\" sizes=\"auto, (max-width: 614px) 100vw, 614px\" \/><\/a><\/p>\n<p><a href=\"http:\/\/salihdeveci.files.wordpress.com\/2013\/04\/141.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3124\" src=\"http:\/\/salihdeveci.files.wordpress.com\/2013\/04\/141.png\" alt=\"14\" width=\"614\" height=\"296\" srcset=\"https:\/\/ittutorial.org\/wp-content\/uploads\/2013\/04\/141.png 1269w, https:\/\/ittutorial.org\/wp-content\/uploads\/2013\/04\/141-300x145.png 300w, https:\/\/ittutorial.org\/wp-content\/uploads\/2013\/04\/141-768x371.png 768w, https:\/\/ittutorial.org\/wp-content\/uploads\/2013\/04\/141-1024x495.png 1024w\" sizes=\"auto, (max-width: 614px) 100vw, 614px\" \/><\/a><\/p>\n<p>As shown below, we have successfully completed Cluster a Node.<\/p>\n<p><a href=\"http:\/\/salihdeveci.files.wordpress.com\/2013\/04\/15.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3125\" src=\"http:\/\/salihdeveci.files.wordpress.com\/2013\/04\/15.png\" alt=\"15\" width=\"614\" height=\"297\" srcset=\"https:\/\/ittutorial.org\/wp-content\/uploads\/2013\/04\/15.png 1263w, https:\/\/ittutorial.org\/wp-content\/uploads\/2013\/04\/15-300x145.png 300w, https:\/\/ittutorial.org\/wp-content\/uploads\/2013\/04\/15-768x372.png 768w, https:\/\/ittutorial.org\/wp-content\/uploads\/2013\/04\/15-1024x495.png 1024w\" sizes=\"auto, (max-width: 614px) 100vw, 614px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n\n<p>&nbsp;<\/p>\n<h4><span style=\"color: #ff0000;\">Do you want to learn Microsoft SQL Server DBA Tutorials for Beginners, then read the following articles.<\/span><\/h4>\n<p><a href=\"https:\/\/ittutorial.org\/sql-server-tutorials-microsoft-database-for-beginners\/\">https:\/\/ittutorial.org\/sql-server-tutorials-microsoft-database-for-beginners\/<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Hi, I will continue to tell\u00a0SQL Server Failover Cluster Installation in this post.<\/p>\n","protected":false},"author":1,"featured_media":3099,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[2227],"tags":[615,2497,617,717,1031,1515,2498,1577,1583,1624,2496,1646,2495,1647],"class_list":["post-6666","post","type-post","status-publish","format-standard","has-post-thumbnail","","category-sql-server-2","tag-failover-cluster","tag-failover-cluster-sql-server-installation","tag-failover-clustering","tag-high-availability","tag-mehmet-salih-deveci","tag-salih-deveci","tag-sql-failover-cluster-installation","tag-sql-server","tag-sql-server-2008","tag-sql-server-cluster","tag-sql-server-cluster-installation","tag-sql-server-failover-cluster","tag-sql-server-failover-cluster-installation","tag-sql-server-high-availability"],"aioseo_notices":[],"jetpack_featured_media_url":"https:\/\/ittutorial.org\/wp-content\/uploads\/2013\/04\/windows-failover-clustering.jpg","jetpack_sharing_enabled":true,"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/6666","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/comments?post=6666"}],"version-history":[{"count":5,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/6666\/revisions"}],"predecessor-version":[{"id":12948,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/6666\/revisions\/12948"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/media\/3099"}],"wp:attachment":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/media?parent=6666"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/categories?post=6666"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/tags?post=6666"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}