{"id":415,"date":"2012-07-30T14:30:47","date_gmt":"2012-07-30T11:30:47","guid":{"rendered":"http:\/\/fatihacar.com\/blog\/?p=415"},"modified":"2012-08-16T16:46:09","modified_gmt":"2012-08-16T13:46:09","slug":"mssql-server-2008-r2-failover-cluster-installation-on-windows-server-2008-r2-enterprise-x64-on-vmware","status":"publish","type":"post","link":"http:\/\/www.fatihacar.com\/blog\/mssql-server-2008-r2-failover-cluster-installation-on-windows-server-2008-r2-enterprise-x64-on-vmware\/","title":{"rendered":"MsSQL Server 2008 R2 Failover Cluster Installation on Windows Server 2008 R2 Enterprise x64 on VMware"},"content":{"rendered":"<p><strong>Failover Cluster System Benefits<\/strong><\/p>\n<ul>\n<li>Protection at the instance level through redundancy<\/li>\n<li>Automatic failover in the event of a failure (hardware failures, operating system failures, application or service failures)<\/li>\n<li>Support for a broad array of storage solutions, including WSFC cluster disks (iSCSI, Fiber Channel, and so on) and server message block (SMB) file shares.<\/li>\n<li>Disaster recovery solution using a multi-subnet FCI or running an FCI-hosted database inside an AlwaysOn availability group. With the new multi-subnet support in Microsoft SQL Server 2012, a multi-subnet FCI no longer requires a virtual LAN, increasing the manageability and security of a multi-subnet FCI.<\/li>\n<li>Zero reconfiguration of applications and clients during failovers<\/li>\n<li>Flexible failover policy for granular trigger events for automatic failovers<\/li>\n<li>Reliable failovers through periodic and detailed health detection using dedicated and persisted connections<\/li>\n<li>Configurability and predictability in failover time through indirect background checkpoints<\/li>\n<li>Throttled resource usage during failovers<\/li>\n<\/ul>\n<p><a href=\"http:\/\/fatihacar.com\/blog\/mssql-server-2008-r2-failover-cluster-installation-on-windows-server-2008-r2-enterprise-x64-on-vmware\/failover-clustering_1\/\" rel=\"attachment wp-att-434\"><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/fatihacar.com\/blog\/resimler\/Failover-Clustering_1.png\" alt=\"\" title=\"SQL Server Failover Clustering\" width=\"549\" height=\"506\" class=\"aligncenter size-full wp-image-434\" srcset=\"http:\/\/www.fatihacar.com\/blog\/resimler\/Failover-Clustering_1.png 549w, http:\/\/www.fatihacar.com\/blog\/resimler\/Failover-Clustering_1-300x276.png 300w\" sizes=\"auto, (max-width: 549px) 100vw, 549px\" \/><\/a><br \/>\n<strong>Preconfiguration on Windows Server For Failover Cluster<\/strong><\/p>\n<blockquote>\n<ul>\n<li>2 Network Adaptor; First Adaptor for PublicLAN, Second Adaptor for Heartbeat Connection.<\/li>\n<li>7 IP Address for Cluster; 2 IP for PublicLAN, 2 IP for Heartbeat, 1 IP for Cluster, 1 IP for ClusterDtc, 1 IP for SQL Server Common Connection Address(ClusterNT)<\/li>\n<li>1 Disk for Local C disk each node. SCSI Bus Sharing have to be None, and Disk&#8217;s Mode have to be Persistent. SCSI Controller Type have to be SCSI Logic SAS<\/li>\n<li>3 RAW Disk for Sharing Disks; First Disk 1 GB for QUORUM, Second Disk 1 GB for MSDTC and Last Disk 100 GB for DATA. RAW disks&#8217;s SCSI Bus Sharing have to be Physical, and Disks&#8217;s Compatibility Mode have to be Physical. SCSI Controller Type have to be SCSI Logic SAS.<\/li>\n<li>Create user on Active Directory and give domain admin privilage. User name can be sqlserver.<\/li>\n<li>Create new organization unit (ou) for cluster machines.<\/li>\n<\/ul>\n<\/blockquote>\n<p><!--more--><br \/>\n<strong>Preconfiguration to Install Failover Cluster on Windows After Windows Server 2008 Installation<\/strong><\/p>\n<blockquote>\n<ul>\n<li>Add sqlserver user to Administrator group.<\/li>\n<li>Make Network configuration for PublicLAN and Heartbeat, And make first network PublicLAN from Advanced Settings.<\/li>\n<li>Add host ip addresses and alias to hosts file.<\/li>\n<li>Shared Disks make online on each node. After Create Volume on each node. Aliases: Q -&gt; QUORUM, M -&gt; MSDTC, S -&gt; DATA<\/li>\n<li>Make Firewalls Disabled.<\/li>\n<li>Windows update complated.<\/li>\n<\/ul>\n<\/blockquote>\n<p><strong>Install Failover Cluster<\/strong><\/p>\n<blockquote>\n<ul>\n<li>Install Failover Clustering from windows features on each node.<\/li>\n<li>Install Application Server with incoming and ountgoing firewall from windows roles on each node.<\/li>\n<li>Check Cluster Validation from Failover Cluster Manager.<\/li>\n<li>If the checking is valid, you can click Create Cluster. (Cluster IP)<\/li>\n<li>Configure Quorum Disk<\/li>\n<li>Create MSDTC Service from Services and applications &gt; Configure .. &gt; Distributed Transaction Coordinator(DTC) (ClusterDtc IP)<\/li>\n<\/ul>\n<\/blockquote>\n<p><strong>Install MsSQL Server 2008 Failover Cluster<\/strong><\/p>\n<blockquote>\n<ul>\n<li>Click Setup form Installation on Node1<\/li>\n<li>Choose Installation Failover Cluster<\/li>\n<\/ul>\n<\/blockquote>\n<p><strong>Add New Node<\/strong><\/p>\n<blockquote>\n<ul>\n<li>Click Setup form Installation on Node2<\/li>\n<li>Choose Add Node<\/li>\n<\/ul>\n<\/blockquote>\n","protected":false},"excerpt":{"rendered":"<p>Failover Cluster System Benefits Protection at the instance level through redundancy Automatic failover in the event of a failure (hardware failures, operating system failures, application or service failures) Support for a broad array of storage solutions, including WSFC cluster disks (iSCSI, Fiber Channel, and so on) and server message block (SMB) file shares. Disaster recovery&#8230;<\/p>\n","protected":false},"author":37,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[11],"tags":[],"class_list":["post-415","post","type-post","status-publish","format-standard","hentry","category-administration-mssql-server"],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p39NFI-6H","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/415","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/users\/37"}],"replies":[{"embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/comments?post=415"}],"version-history":[{"count":13,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/415\/revisions"}],"predecessor-version":[{"id":436,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/415\/revisions\/436"}],"wp:attachment":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/media?parent=415"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/categories?post=415"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/tags?post=415"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}