Windows Server 2008 R2 Archives - SIOS SANless clusters

Quick Start Guide: SQL Server Clusters On Windows Server 2008 R2 In Azure

Windows Server 2008 R2 lives on in the cloud. So here’s a quick start guide for all those who need help with SQL Server Clusters On Windows Server 2008 R2. Yes, Azure does support Windows Server 2008 R2 and older versions of SQL Server including 2008 R2 and 2012. Of course Always On Availability Groups wasn’t introduced until SQL 2012 and even then you probably want to avoid Availability Groups due to some of the performance issues associated with that version.

Need to support older versions of SQL Server or Windows? Build SANless clusters based on SIOS DataKeeper as mentioned in the Azure documentation.

Quick Start Guide: SQL Server Clusters On Windows Server 2008 R2 In Azure — https://docs.microsoft.com/en-us/azure/virtual-machines/windows/sql/virtual-machines-windows-sql-high-availability-dr

SQL Server Clusters On Windows Server 2008 R2 – How To Get It Done?

In a nutshell here are the steps for SQL Server Clusters On Windows Server 2008 R2

Provision two cluster servers and a file share witness in the same Availability Set. This places all three quorum votes in different Fault and Update Domains.
There is a hotfix for SQL 2008 R2 clusters in Azure to enable the listener used by both AGs and FCIs. https://support.microsoft.com/en-us/help/2854082/update-enables-sql-server-availability-group-listeners-on-windows-serv
Install that and all other OS updates.
Provision the storage on each server.
Format NTFS and give drive letters.
Each cluster node needs identical storage.
Enable Failover Clustering and .Net 3.5 Framework on each server
Add the servers to the domain
Create the basic cluster, but USE POWERSHELL and specify the cluster IP address. If you use the GUI to create the cluster, it will get confused and provision a duplicate IP address. Connecting via the GUI will enable you to connect to the cluster from one of the nodes. If you connect, you can correct the problem by specifying a static IP address to be used by the cluster resource. Here is an example of the Powershell usage to create the cluster
```
New-Cluster -Name cluster1 -Node sql1,sql2 -StaticAddress 10.0.0.101 -NoStorage-
```
Add a File Share Witness to the cluster
Install DataKeeper on both cluster nodes
Create the DataKeeper Volume Resources and make sure they are Available Storage
Install SQL into the cluster as you normally would in a shared storage cluster.
Configure the Azure ILB and run the powershell script to update the SQL Cluster IP resource to listen on the Probe Port.

All of this is fully documented on the SIOS documentation page, Deploying DataKeeper Cluster Edition in Azure

If you have any questions about high availability for SQL Server or disaster recovery in Azure, AWS or Google Cloud, do visit our pages on clustering and other related topics.
Reproduced with permission from Clusteringformeremortals.com

It seems as if there could be a vulnerability which would allow unauthorized access to administrative shares! You will certainly want this patch ASAP and also don’t forget to check the permission levels on your administrative shares after you apply this patch for Windows Server 2008 R2 Clusters.

http://www.microsoft.com/technet/security/bulletin/MS10-086.mspx

Recommendation. Microsoft recommends that customers consider applying the security update using update management software, or by checking for updates using the Microsoft Update service. Additionally, after applying the update, customers should check the permissions on existing cluster disk administrative shares and set the proper access levels for their environment.

Reproduced with permission from https://clusteringformeremortals.com/2010/10/13/important-security-update-for-windows-server-2008-r2-clusters/