I am getting below error while enabling the SQL Server always on using powershell.
***
Enable-SqlAlwaysOn : An attempt to connect to WMI on 'XXXXXXXXXXXX' failed with following error: SQL Server WMI provider is not available on XXXXXXXXXXXX..
***
Windows version: Windows Server 2019 Standard Edition
SQL Server Version: SQL Server 2019
I have already tried registering mofcomp.exe sqlmgmproviderxpsp2up.mof from command prompt and rebooting the server.
Earlier only 13.000 folder was exist in C:\Windows\assembly\GAC_MSIL\Microsoft.SqlServer.SqlManagement, but I have created 14.000 and 15.000 folder as well and copied the required dll. still did not work.
Any help and solution will be appreciated.
Thanks,
Rahul