Open the data-files directory and create two more folders called “User-Data” and “System-Data” Open the Log-Files directory and create a folder called User-Logs Open the TempDB directory and create another folder called “Temp-DATA” Repeat Steps 1 to 9 on the second SQL server node In Active Directory Users and Computers, create a Cluster Name Object. This CNO will be detailed in your Low Level Design e.g SkypeSQLAO-01 Add both SQL node computer accounts to the CNO security permissions and assign full control privileges Installing Failover Cluster for AlwaysOn Windows Failover Cluster (FCI) is required to cluster the operating systems of each SQL node to participate in AlwaysOn. SQL is installed on both nodes as local applications rather than inside the FCI as in traditional clustering. This means as well as all local drive letters and folder hierarchies used must be identical across both nodes, the instance installed must also match. In a two node FCI, a witness is required to maintain cluster quorum. This can be either a file share on a server outside the cluster, or by shared hard disk using iSCSI or Fiber connections to both servers. Please revert to your Low Level Design for the quorum witness method for your deployment. For the purpose of this guide, a shared disk witness will be used. Install the Windows Clustering feature on both SQL nodes Open failover clustering console on one node, and click Create Cluster Press next to begin, add in both SQL nodes that will participate in the cluster and press next Enter the cluster name object created in the pre-requisites section, and enter an available IP address for the cluster, press next Deselect add all available storage to the cluster, and press next Press finish when the cluster creation has finished. There will be warnings regarding no quorum disk found, however, this will be resolved in the following steps. Select the cluster you created in failover cluster console and click validate cluster Press next, through the wizard until the checks are performed It is normal at this stage for the validation to produce warnings, but no failures should be present. Expand storage in the cluster and select Pools and click New Storage Pool Provide a Name for the storage pool e.g Pool01, and press next Add all your available primordial storage to the pool and press next Press Create to create the pool Verify the pool is online and healthy by viewing failover cluster manager
Open the data-files directory and create two more folders called “User-Data” and “System-Data” Open the Log-Files directory and create a folder called User-Logs Open the TempDB directory and create another folder called “Temp-DATA” Repeat Steps 1 to 9 on the second SQL server node In Active Directory Users and Computers, create a Cluster Name Object. This CNO will be detailed in your Low Level Design e.g SkypeSQLAO-01 Add both SQL node computer accounts to the CNO security permissions and assign full control privileges Installing Failover Cluster for AlwaysOn Windows Failover Cluster (FCI) is required to cluster the operating systems of each SQL node to participate in AlwaysOn. SQL is installed on both nodes as local applications rather than inside the FCI as in traditional clustering. This means as well as all local drive letters and folder hierarchies used must be identical across both nodes, the instance installed must also match. In a two node FCI, a witness is required to maintain cluster quorum. This can be either a file share on a server outside the cluster, or by shared hard disk using iSCSI or Fiber connections to both servers. Please revert to your Low Level Design for the quorum witness method for your deployment. For the purpose of this guide, a shared disk witness will be used. Install the Windows Clustering feature on both SQL nodes Open failover clustering console on one node, and click Create Cluster Press next to begin, add in both SQL nodes that will participate in the cluster and press next Enter the cluster name object created in the pre-requisites section, and enter an available IP address for the cluster, press next Deselect add all available storage to the cluster, and press next Press finish when the cluster creation has finished. There will be warnings regarding no quorum disk found, however, this will be resolved in the following steps. Select the cluster you created in failover cluster console and click validate cluster Press next, through the wizard until the checks are performed It is normal at this stage for the validation to produce warnings, but no failures should be present. Expand storage in the cluster and select Pools and click New Storage Pool Provide a Name for the storage pool e.g Pool01, and press next Add all your available primordial storage to the pool and press next Press Create to create the pool Verify the pool is online and healthy by viewing failover cluster manager
Preparing%20for%20Skype%20for%20Business%20-%20Feb%202016.docx