Failed to create a SQL SERVER user group!

Question

When the SQL SERVER is installed, a message is displayed indicating that the user group cannot be created. I see that the local user group data is empty，how can i do ?

I have 100 of my software installed on my computer and I don't want to erase the data and reinstall it completely.

I tried to keep the data and reinstall the system, but the problem didn't work out.

I've reviewed the transcript of the incident, and there are no obvious errors.

Answer 1

Hello there,

This issue occurs if the [NT AUTHORITY\SYSTEM] account is missing from the SQL Server login or if the account lacks the necessary permissions to create the high-availability group.

To resolve this issue, use one of the following methods in the below article.

Error 41131 when creating availability group

https://learn.microsoft.com/en-us/troubleshoot/sql/database-engine/availability-groups/error-41131-create-availability-group

Hope this resolves your Query !!

--If the reply is helpful, please Upvote and Accept it as an answer--