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 | Other
0 comments No comments
{count} votes

Answer accepted by question author
  1. Dan Guzman 9,411 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

Your answer

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