​This is go through the steps required to install a SQL 2012 AlwaysOn Availability Group (AG) or AlwaysOn Cluster.

• • Install SQL Server on both Servers. (Note: need microsoft sql 2012 enterprise version)
  • Make sure this 2 sql server are part of the domain member server
  • Start the SQL Server Configuration Manager on both SQL Server.

• Select SQL Server Services -> Right-click SQL Server (MSSQLSERVER) -> Properties.
• Select the AlwayOn High Availability tab -> Enable AlwaysOn (tick-box) -> OK
  
• Restart the SQL Server (MSSQLSERVER) Service
• Within SQL Management Studio right-click the first SQL server -> New Query
• Enter the following query. Ensure you enter the other server’s computer name. Hit Execute
• use [master]
  GO
  CREATE LOGIN [DOMAINCOMPUTERNAME$] FROM WINDOWS
  GO
  GRANT CONNECT ON ENDPOINT::[Hadr_endpoint] TO [DOMAINCOMPUTERNAME$]
  GO
• select the database and backup the database you want to make it AlwaysOn
• Back within SQL Management Studio, Right-click AlwaysOn High Availability -> New
• Click next
• Enter in a Group name (Best to put the Application Name). Hit Next
• Select the databases you want to add to the group. Hit Next​
• Select add replica
• Tick the automatic failover and select Readable Secondary if you require.  Then Select the Listener tab.​
• Select the LAN subnet and enter in an IP address you wish to use for the AG Listener
• Enter in a share that both servers have access to, this needs to be on 1 of the two servers. Create on if one doesn’t exist. SQL will backup the databases onto this share to restore on the second server.​
• Ensure there are no warnings or errors then hit next. Address all warnings/errors prior to hitting next. You can re-run the validation once resolved.
• Click “Finish”​

  You should see now be able to expand Availability Groups and see your newly created Group.​

  For more Best Value IT Solutions, Contact US