How to Create SQL Server 2012 AlwaysOn Availability Group With Windows Server Failover Cluster

37 thoughts on “How to Create SQL Server 2012 AlwaysOn Availability Group With Windows Server Failover Cluster”

• Super tutorial, thanks a lot

• Great tutorial to understand how it works and how to config. Thanks a lot!

• Great Video, Thanks.

• Hi. I am unable to connect Node2 how can i do this?

• you are the best

• Awesome man thanks for this tutorial. very helpful.

• Thank you for the tutorial. Have a question. What is the difference configuring Windows failover cluster, and then installed SQL failover cluster on that scenario vs enabling always on availability ? By enabling always on, we do get more flexibility over SQL db operations ?

• Speak Slowly ….see the impact of fast speech at 16:07 ….Looks good is said goods look

• What type of SQL installation done in your nodes? Standard or Failover ?

• hi vikas…. for this clustering HB is required or not

• 7:39 you change security setting on the the wrong folder. It should not be the user folder

• Is it a fixed number (1433.5022) for SQL ports?
  
  Can I use other numbering for the SQL ports?

• You are the best. Thanks alot

• Simplest Way . Good Effort . Love from Pakistan

• for two node failover clustering is it work with standard edition or we need datacenter

• Great work. Love from Pakistan

• Great video thanks , but i need help with log shipping to external sever, can you help me ?

• great it is work

• This video was very helpful in getting me started . Thanks.

• Nice one

• Hi, I really like your videos. They help me a lot. Sorry for putting a feature request video here, but I could really need your advice and demo on migrating databases and user credentials from SQL Server 2012/Win2012R2 to SQL Server 2017/Win2016 using Microsoft SQL Server Migration Assistant (SSMA). Full migration from 1 server to an other, or even to Azure SQL.

• Hi Vikas, Can I get this VM ware with Sql server ISO setup for practice

• what Happened if SQL-node01 is crashed completely and never repair. Should I have to build new machine and re-create HA with SQL-node2? is that easy fix or not?

• Then..what is the role of WSFC here?.. I didn't saw any use of it here… because failover happened as of mirroring.
  Please clear my confusion here.. thanks in advance

• Hi, I have a quick question. I am fairly new at this, and I am having trouble attempting to figure out where the SQL-Admin@VICTORINFOSSOL.COM instance is coming from when you are creating the fileshare witness folder.. Is it just an user account you've created prior to the recording or is it something else? Thanks in advance for your clarification!

• Hello Vikas the way you explaining is perfect can you teach me.

• good demo. But it ll be great if you can speak and go a bit slowly. I am from Canada and it was hard to keep up with up with ur fast paced accent

• Good demo for the basic installation. Helpful👍

• Excellent video! Thank you.

• Hi Vikas, would it migrate all hard drives data we created like log transactions , log , database etc

• Hi vikas, nice video. I am facing issue the connectivity to the sql always on cluster from third party application.
  Can u please help me with that.

• Hi thank you for your contribution.
  Can you please also make a prerequisite video for this video in which you create such vmware workstation environment from scratch that is installing vmware workstation 11 and making 3 VMs installing Windows server on each, making active directory domain controller and bringing all the VMs under one domain.
  Because I am having trouble to create such environment and unable to find related tutorials.

• I have a problem appeared about validation to create availability group is ((
  Checking for compatibility of the database file location on the secondary replica resulted in an error.(Microsoft.SqlServer.Management.HadrTasks))

• It's really a helpful video for beginners, all are educated step by step Thanks Vikas!

• Hi! I have two important questions. In this configurations both databases (primary and secondary) are read-write? When i want to connect to database "Demo" i should to use cluster name as SQL server name in connection string?

• Good basics with minimal setup. You may shrink the video time by skipping the installation times (sql server, cluster etc) out of video.

• Excellent video! Thank you.

Comments are closed.