Failed to create a SQL SERVER user group!

wintrue 0 Reputation points
2023-03-20T06:35:55.98+00:00

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.

1

2

3

Windows
Windows
A family of Microsoft operating systems that run across personal computers, tablets, laptops, phones, internet of things devices, self-contained mixed reality headsets, large collaboration screens, and other devices.
4,795 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,808 questions
Windows 11
Windows 11
A Microsoft operating system designed for productivity, creativity, and ease of use.
8,277 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Limitless Technology 43,966 Reputation points
    2023-03-21T15:14:57.2766667+00:00

    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--

    0 comments