SQL 2022 Std ALWAYS ON Contained Availability Group

Alen Vukovic 20 Reputation points

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



SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
11,629 questions
0 comments No comments
{count} votes

Accepted answer
  1. Dan Guzman 8,591 Reputation points

    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