{"id":628,"date":"2024-10-05T22:45:00","date_gmt":"2024-10-05T22:45:00","guid":{"rendered":"https:\/\/humtechno.com\/intro\/?p=628"},"modified":"2024-10-06T13:04:50","modified_gmt":"2024-10-06T13:04:50","slug":"configuration-of-alwayson-cluster-and-windows-cluster","status":"publish","type":"post","link":"https:\/\/humtechno.com\/intro\/2024\/10\/05\/configuration-of-alwayson-cluster-and-windows-cluster\/","title":{"rendered":"Configuration of SQL SERVER Alwayson Cluster and Windows Cluster"},"content":{"rendered":"\n\n\n\n\n<p><a href=\"https:\/\/humtechno.com\/intro\/wp-content\/uploads\/2024\/10\/AlwaysOn-Cluster-Installation-1.pdf\">Download File<\/a><\/p>\n\n\n\n<figure class=\"wp-block-embed is-type-video is-provider-youtube wp-block-embed-youtube wp-embed-aspect-16-9 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<iframe title=\"SQL Server Alwayson Cluster | Complete Installation\" width=\"500\" height=\"281\" src=\"https:\/\/www.youtube.com\/embed\/VtJD4RzX6RM?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe>\n<\/div><figcaption class=\"wp-element-caption\">SQL Server Alwayson Cluster<\/figcaption><\/figure>\n\n\n\n<p><strong>Windows Operating System<\/strong> : Windows Server 2012<br>SQL Server Software : C:\\Kamran\\Software\\sql2016ent\\Microsoft SQL Server 2016 Enterprise SP1 X64<br><strong>Database Node 1<\/strong> : SQLN1 &#8211; 192.168.100.148<br><strong>Database Node 2<\/strong> : SQLN2 &#8211; 192.168.100.151<br><strong>Windows Domain<\/strong> : HST &#8211; 192.168.100.157<br><strong>Windows Cluster<\/strong> : WCLSQL &#8211; 192.168.100.161<br><strong>SQL Server Availability Group<\/strong> : SCLSQL<br><strong>SQL Server Listener<\/strong> : LCLSQL &#8211; 192.168.100.162<br><strong>Sharing Folder<\/strong> : \\kkdomain\\CLQuorum<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">High Level Steps<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Create VM of Both Database Machines<\/li>\n\n\n\n<li>Install Operating System on Both Database Machines<\/li>\n\n\n\n<li>Enable Networks and Assign IP Address on both Machines<\/li>\n\n\n\n<li>Disable Firewall on both Machines<\/li>\n\n\n\n<li>Join Domain with Both Database Machines<\/li>\n\n\n\n<li>Create User \u201cdba\u201d for windows Login on Domain Controller<\/li>\n\n\n\n<li>Mount SQL Server CD on both Database Machines<\/li>\n\n\n\n<li>Verify Names of Both Database Machines<\/li>\n\n\n\n<li>Create Folders for Database Files if Possible each Create on Separate Drives.<\/li>\n\n\n\n<li>Install SQL Server on both Database Machines<\/li>\n\n\n\n<li>Copy SSMS (Management Studio) Software on Both Database Nodes.<\/li>\n\n\n\n<li>Install SSMS (Management Studio) Software on Both Database Nodes.<\/li>\n\n\n\n<li>Install Failover Cluster on both Database Nodes from Admin users.<\/li>\n\n\n\n<li>Create Windows Cluster on both Database Nodes from Admin users.<\/li>\n\n\n\n<li>Create Shared Folder for Quorum Disk.<\/li>\n\n\n\n<li>Configure Quorum Disk on Windows Cluster.<\/li>\n\n\n\n<li>Enable Alwayson Availability group options in SQL Server Service on both Databases nodes.<\/li>\n\n\n\n<li>Create New Empty Database on SQL Server<\/li>\n\n\n\n<li>Take Database backup of New Empty Database<\/li>\n\n\n\n<li>Create SQL Server Availability group from Database Node<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">Pre-Requisites<\/h2>\n\n\n\n<h2 class=\"wp-block-heading\"><br>Windows Machine Configuration<\/h2>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Install OS on Two Database Machines<\/li>\n\n\n\n<li>Enable Network and Provide IP Address on Both Machines<\/li>\n\n\n\n<li>Disable Firewall on Both Machines.<\/li>\n\n\n\n<li>Join Both Machines on Windows Domain e.g. &#8220;HST&#8221;<\/li>\n<\/ol>\n\n\n\n<p><\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Windows User Privileges of Windows Domain.<\/h2>\n\n\n\n<p><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Create Windows User &#8220;DBA&#8221; on Domain Controller and Grant Required Privileges.<\/li>\n\n\n\n<li>Enable Machine for Remote Desktop on user &#8220;DBA&#8221;.<\/li>\n\n\n\n<li>Allow &#8220;DBA&#8221; User Local Admin of Computer add in Local &#8220;Administrators&#8221; Group.<\/li>\n<\/ul>\n\n\n\n<ol start=\"2\" class=\"wp-block-list\">\n<li><\/li>\n<\/ol>\n\n\n\n<ol class=\"wp-block-list\">\n<li><\/li>\n<\/ol>\n\n\n\n<h2 class=\"wp-block-heading\">SQL Server Always on Configuration<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Login with DBA User on Both Machines<\/li>\n\n\n\n<li>Mount SQL Server ISO on Both Machine<\/li>\n\n\n\n<li>Verify Name of Both Database Machine<\/li>\n\n\n\n<li>Create Folders on both Databases Machines if Possible create Folder on Separate Drives.\n<ul class=\"wp-block-list\">\n<li>Create Folders<\/li>\n\n\n\n<li>Database<\/li>\n\n\n\n<li>Backups<\/li>\n\n\n\n<li>DataFiles<\/li>\n\n\n\n<li>LogFiles<\/li>\n\n\n\n<li>TempFiles<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>Install SQL Server on Both Machines.<\/li>\n\n\n\n<li>Copy SSMS Software on Both Machines C:\\software\\SSMS-Setup-ENU<\/li>\n\n\n\n<li>Install SSMS Software on Both Machines<\/li>\n\n\n\n<li>Login with Admin User on both Machines<\/li>\n\n\n\n<li>Install Failover Cluster on Both Databases Machine &gt; Server Manager &gt; add Roles and Features &gt; \u201cFailover Clustering&#8221;<\/li>\n\n\n\n<li>Login Database Node 1 Machine as Admin User.<\/li>\n\n\n\n<li>Create Windows Cluster: Server Manager &gt; Tools &gt; Fail Over Cluster Manager &gt; Create Cluster\n<ul class=\"wp-block-list\">\n<li>Note: Uncheck &#8220;All add Eligible storage to the cluster&#8221;<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>Create Shared Folder for Quorum Disk\n<ul class=\"wp-block-list\">\n<li>IP: 192.168.100.157 C:\\Disks\\SCLSQL-Quorum<\/li>\n\n\n\n<li>Folder Name = CLQuorum<\/li>\n\n\n\n<li>Permission: Read \/ Write and Add Security for \u201cWCLCluster$\u201d All Privilege<\/li>\n\n\n\n<li>Sharing Folder: \\kkdomain\\CLQuorum<\/li>\n\n\n\n<li>Login Database Node 1 Machine as Admin User.<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>Configure Server Manager &gt; Tools &gt; Fail Over Cluster Manager &gt; More Action &gt; Configure Cluster Quorum Settings\n<ul class=\"wp-block-list\">\n<li>Select Quorum Witness &gt; Configure File Sharing Witness<\/li>\n\n\n\n<li>Sharing Folder: \\kkdomain\\CLQuorum<\/li>\n\n\n\n<li>On Error : Change Permission of Share Folder then &#8220;Re-Execute Above Steps Again for Quorum Disk Creation&#8221;<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>Login Database Node 1 Machine as &#8220;dba&#8221; User.<\/li>\n\n\n\n<li>Enable AlwaysOn Availability Groups Feature on SQL Server Services on Both Databases nodes\n<ul class=\"wp-block-list\">\n<li>SQL Server 2016 Configuration Manager&gt; Run as Administrator&gt; enter Dba User \/ Password &gt; SQL Server Service &gt; SQL SERVER (MSSQLSERVER) &gt; Properties &gt;Always on High Availability &gt; Enable Alwayson Availability Groups &gt; Apply &gt; Ok &gt; Ok<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>Restart SQL Server Services\n<ul class=\"wp-block-list\">\n<li>SQL Server 2016 Configuration Manager&gt; Run as Administrator&gt; enter Dba User \/ Password &gt; SQL Server Service &gt; SQL SERVER (MSSQLSERVER) &gt; Right Click &gt; Restart<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>Login as &#8220;DBA&#8221; User on DB Node 1<\/li>\n\n\n\n<li>Login on SQL Server Management Studio\n<ul class=\"wp-block-list\">\n<li>Open &#8220;SQL Server Management Studio\u201d &gt; Authentication &gt; SQL Server Authentication &gt; Login \u201csa\u201d and enter Password &gt; Connect.<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>Create New Empty Database &gt; Databases &gt; New Databases &gt; Enter Name of Database &gt; Ok<\/li>\n\n\n\n<li>Create Backup on New Test Database &gt; Add Backup Device &gt; Ok<\/li>\n\n\n\n<li>Create Alwayson High Availability Group\n<ul class=\"wp-block-list\">\n<li>Expend SQLN1 &gt;Always on High Availability &gt; Right Click &gt; New Availability Group Wizard<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<p><\/p>\n\n\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":2,"featured_media":372,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"pagelayer_contact_templates":[],"_pagelayer_content":"","footnotes":""},"categories":[5,4],"tags":[98,97,96,99],"class_list":["post-628","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-ms-sql","category-sql-server","tag-alwayson","tag-sql-server","tag-sql-server-alwayson-cluster","tag-sql-server-clustering"],"_links":{"self":[{"href":"https:\/\/humtechno.com\/intro\/wp-json\/wp\/v2\/posts\/628","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/humtechno.com\/intro\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/humtechno.com\/intro\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/humtechno.com\/intro\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/humtechno.com\/intro\/wp-json\/wp\/v2\/comments?post=628"}],"version-history":[{"count":6,"href":"https:\/\/humtechno.com\/intro\/wp-json\/wp\/v2\/posts\/628\/revisions"}],"predecessor-version":[{"id":640,"href":"https:\/\/humtechno.com\/intro\/wp-json\/wp\/v2\/posts\/628\/revisions\/640"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/humtechno.com\/intro\/wp-json\/wp\/v2\/media\/372"}],"wp:attachment":[{"href":"https:\/\/humtechno.com\/intro\/wp-json\/wp\/v2\/media?parent=628"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/humtechno.com\/intro\/wp-json\/wp\/v2\/categories?post=628"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/humtechno.com\/intro\/wp-json\/wp\/v2\/tags?post=628"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}