When will Azure AD Connect support SQL 2022?

Question

When will Azure AD Connect support SQL 2022?

Chiversion 41

Currently (mid-2023) AAD Sync (AAD Connect) on-premise installations only support SQL 2019 databases. Has a date been announced when SQL 2022 will be supported?

0 comments

Answer accepted by question author

ZoeHui-MSFT 41,551

Hi @Chiversion,

SQL Server 2022 (16.x) introduces support for Azure Active Directory (Azure AD) authentication, on both Windows and Linux on-premises, and SQL Server on Windows Azure VMs.

Check it out here.

https://learn.microsoft.com/en-us/sql/relational-databases/security/authentication-access/azure-ad-authentication-sql-server-overview?view=sql-server-ver16

Regards，

Zoe Hui

If the answer is helpful, please click "Accept Answer" and upvote it.

Chiversion 41 Reputation points

2023-05-17T17:08:10.56+00:00
I appreciate the answer, and while the documentation appears to superficially answer my question, the only direct answer I can find is here:

https://learn.microsoft.com/en-us/azure/active-directory/hybrid/connect/how-to-connect-install-prerequisites

SQL Server used by Azure AD Connect

Azure AD Connect requires a SQL Server database to store identity data. By default, a SQL Server 2019 Express LocalDB (a light version of SQL Server Express) is installed. SQL Server Express has a 10-GB size limit that enables you to manage approximately 100,000 objects. If you need to manage a higher volume of directory objects, point the installation wizard to a different installation of SQL Server. The type of SQL Server installation can impact the performance of Azure AD Connect.

If you use a different installation of SQL Server, these requirements apply:

Azure AD Connect support all mainstream supported SQL Server versions up to SQL Server 2019. Please refer to the SQL Server lifecycle article to verify the support status of your SQL Server version. SQL Server 2012 is no longer supported. Azure SQL Database isn't supported as a database. This includes both Azure SQL Database and Azure SQL Managed Instance.

1 additional answer

Your answer

Chiversion 41 Reputation points

2023-05-17T17:08:10.56+00:00

I appreciate the answer, and while the documentation appears to superficially answer my question, the only direct answer I can find is here:

https://learn.microsoft.com/en-us/azure/active-directory/hybrid/connect/how-to-connect-install-prerequisites

SQL Server used by Azure AD Connect

Azure AD Connect requires a SQL Server database to store identity data. By default, a SQL Server 2019 Express LocalDB (a light version of SQL Server Express) is installed. SQL Server Express has a 10-GB size limit that enables you to manage approximately 100,000 objects. If you need to manage a higher volume of directory objects, point the installation wizard to a different installation of SQL Server. The type of SQL Server installation can impact the performance of Azure AD Connect.

If you use a different installation of SQL Server, these requirements apply:

Azure AD Connect support all mainstream supported SQL Server versions up to SQL Server 2019. Please refer to the SQL Server lifecycle article to verify the support status of your SQL Server version. SQL Server 2012 is no longer supported. Azure SQL Database isn't supported as a database. This includes both Azure SQL Database and Azure SQL Managed Instance.

Answer 1

Andy David - MVP 160.3K MVP Volunteer Moderator

I havent seen anything official, but I would assume it would be soon since the mainstream support for SQL 2019 ends in 2025:

https://learn.microsoft.com/en-us/lifecycle/products/sql-server-2019

Chiversion 41 Reputation points

2023-05-17T17:10:12.7133333+00:00

Thanks, this is what I'd figured myself. The official documentation only states that 2019 and below is supported. EOL fast approaches for that version and I'm displeased that the documentation omits even speculation on future acceptance of later SQL versions.

Share via

When will Azure AD Connect support SQL 2022?

1 additional answer

Your answer