Share via

SQL 2022 Std ALWAYS ON Contained Availability Group

Alen Vukovic 20 Reputation points
2023-11-17T10:57:35.4366667+00:00

I have a problem when creating SQL contained Availability Group ag_error

Message error;

"Failed to create availability group 'AG1' with contained clause. It is invalid for this edition. Remove contained clause and retry the operation. "

SQL version - Microsoft SQL Server 2022 Std (RTM-CU9) (KB5030731)

I can create SQL AG without contained option without any problem

BR

Alen

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,163 questions
0 comments
Accepted answer
  1. Dan Guzman 9,241 Reputation points
    2023-11-17T11:53:07.5733333+00:00

    As the error message suggests, this is expected behavior.

    The RDBMS high availability section of the Editions and supported features documentation of SQL Server 2022 lists Contained availability groups as available only on Enterprise, Developer, and Evaluation Editions).

    1 person found this answer helpful.

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.