Failed to Create Availability Group, SQL Server 2014 error 41042 encountered
We were moving our SQL server boxes from one domain to
another domain and after successful movement to the new domain, including
windows cluster, Server's ,SQLServers, we have encountered the issues in Always on availability group while recreating .
We had encountered
the error SQL Server 2014 error 41042, Failed to Create availability group
"Microsoft SQL Server, Error: 41042".
Below are the easy steps to resolve this issue
Go to Windows Fail over Cluster Manager console and “delete” the Resources/Listener which you are not
able to create.
Then go the below Registry
path for all servers where the Availability group exists.
“ HKEY_LOCAL_MACHINE\Cluster\HadrAgNameToldMap”
Delete the entries which are not able to create/failed
Then re- run the wizard!!!!!!!!!!!!!!!!!!!!
