Error:
ERROR_SMO_NEEDED_FOR_SQL_PROVIDER
Solution, Install Client Tools Connectivity from your installation files:
Error:
ERROR_SMO_NEEDED_FOR_SQL_PROVIDER
Solution, Install Client Tools Connectivity from your installation files:
Domain: maykonrds.site
SQL Server 01: sql1
SQL Server 02: sql2
On your domain controller create an object account and disable, I created SQLCluster computer object:
Give them permission to the user who will create the Cluster, in my case is maykonsql.
Install the failover cluster on both servers (sql1 and sql2), on powershell:
>Install-WindowsFeature -Name Failover-Clustering -IncludeManagementTools
Open the cluster and do a validation:
After validation create the cluster:
The cluster name needs to be the object that you created on your Active Directory.
Install SQL Server on SQL1 and SQL2 (Standalone Installation).
After that Enable the Always on SQL Configuration Manager - SQL Server Services - Check Enable Always on Availability Groups for sql1 and sql2:
Go to SQL Always On High Availability - New Availability Group Wizard:
Type a name:
Add your database:
Add a replica (sql2):
Select the synchronization preference:
Add a listerner (You can create a listerner on the Wizard as well).