How to create MS SQL Cluster Shared Disk on VMware Cloud on AWS

Posted on by — No Comments ↓

So you have been struggling to setup shared disk between two windows servers for a while now? Cant power on the second VM? I hear ya and been there. You have come to the right place as I detailed the whole procedure out for you in easy to follow steps. Let’s get started.

Create 2 new Windows VM’s in your VMware Cloud on AWS SDDC

Power on both VM’s and make sure Windows is running and configured

Create a new storage policy

Click Menu, then Policies and Profiles

Select VM Storage Policies and click create

Provide a name and description and Click Next

Select the following and click next

Accept the defaults or change for your environment and click next

For storage rules leave as default and click next

Change to thick provisioned and click next

If all worked storage should be compatible and click next

Click Finish

Shutdown and power of both VM’s

Edit setting on the first VM and add a new SCSI Controller

Set the following and click OK

  1. VMware Paravirtual
  2. Physical
  3. Click OK

Edit settings again on the first VM and add a Hard Disk

Set the following settings and click OK

NOTE: Make sure the Virtual Device node is the new SCSI Controller we just created above

  1. Choose the Storage Policy we created earlier
  2. No Sharing
  3. Select Independent – Persistent
  4. Choose the SCSI controller we created earlier
  5. Click OK

Now edit settings on the second Windows VM and add a SCSI controller

Configure the following settings and click OK

  1. VMware Paravirtual
  2. Physical
  3. Click OK

Now edit settings on the second Windows VM again and Add and Existing Hard Disk and click OK

Browse to the first Windows VM and select the new hard disk we created earlier and press ok

Configure the following setting and click OK

NOTE: Again, make sure the Virtual Device node is the new SCSI Controller we just created above

  1. Choose the Storage Policy we created earlier
  2. No Sharing
  3. Select Independent – Persistent
  4. Choose the SCSI controller we created earlier
  5. Click OK

Power on both VM’s

Login to each VM and open Computer Management and notice the new Drive available on Both

Now you can configure Windows Failover Clustering

Remember sharing is caring!

Leave a Reply

Your email address will not be published. Required fields are marked *

*

This site uses Akismet to reduce spam. Learn how your comment data is processed.