SQL Server: Failover Cluster

Hi, My name is Jimmy Sam. If you need DBA help, please email to jimmy_sam001@yahoo.com for further discussion. Thanks.

top   prev   next  

SQL Server Failover Cluster


-- Windows Cluster
Windows Clustering Step By Step 

Installing the Failover Cluster Feature and Tools in Windows Server 2012 _ 
"Server Manager" --> Local Server --> Manage --> Add Roles and Features 
                 --> Features --> Failover Clustering

Creating a Windows Server 2012 Failover Cluster
"Server Manager" --> Local Server --> Tools --> Failover Cluster Manager

Failover Cluster Step-by-Step Guide: Configuring a Two-Node File Server Failover Cluster 

Failover Cluster Step-by-Step Guide: Configuring Accounts in Active Directory 

How to Create a Cluster in a Restrictive Active Directory Environment 

Cluster Name Object (CNO)
Virtual Computer Object (VCO)
Create Computer Objects permissions
the CNO must have Create Computer Objects privileges in the OU it currently resides in to be able to create VCO's.

-- SQL Server Database Cluster
Clustering SQL Server 2012 on Windows Server 2012 Step-by-Step  
1. Install "SteelEye DataKeeper" Cluster Edition
instead of a shared disk resource, it is a replicated disk resource.

   Launch the DataKeeper UI on PRIMARY and click Connect to Server. 
   Connect to PRIMARY and then connect to SECONDARY

   Open "Failover Cluster Manager" to view status
   "Server Manager" --> Tools --> Failover Cluster Manager

2. Launch "SQL Server 2012 Setup Wizard" 
   -->installation 
   -->Add node to a SQL Server failover cluster"
 
   "Cluster Disk Selection": DataKeeper Volume E

   Open "Failover Cluster Manager" to view status

Windows Service Account: ( SSPI ) 

Windows managed service account ( dsa.msc, dsacls, ADSIEdit.msc  ) 

To install the .NET Framework and the Active Directory module for Windows PowerShell 
1): Click Start, point to Administrative Tools, and then click Server Manager.
2): Under Features, click Add Features.
3): On the Select Features page of the Add Features Wizard, 
    expand NET Framework 3.5.1 Features, 
    and then select .NET Framework 3.5.1.
4): Click Next, and then click Install.

1): Expand Remote Server Administration Tools and AD DS and AD LDS Tools, 
    and then select Active Directory PowerShell Snap-in.
2): Click Next, and then click Install.
3): When the installation is complete, close the Add Features Wizard.

create service acccount ( powershell ):
New-ADServiceAccount [-SAMAccountName ] [-Path ]

Associate the new MSA to the computer account by running the following command
Add-ADComputerServiceAccount [-Identity]  

PowerShell: Creating Active Directory Managed Service Accounts 

Service Accounts Step-by-Step Guide 

Managed Service Accounts ( exchange/IIS yes, Sql Server No ) 

Windows Clustering 

Failover Cluster Step-by-Step Guide: Configuring a Two-Node File Server Failover Cluster 

In Chinese: SQL AG Alwayson In Windows Server 2012 WSFC 
_ 


top   prev   next  

SQL FCI


SQL FCI I 
SQL FCI II 
SQL FCI III 
SQL FCI IV 




top   prev   next  

FCI Quorum

quorum 

quorum without shared storage 

Implement a SQL Server HA failover solution without shared storage 




top   prev   next  

Service Account: Domain Admin

service account best practice: Group Managed Service Accounts 
Active Directory automatically updates the group managed service account password without restarting services