Forum Discussion
Entra ID Connect Sync - Issue Updating the SQL 2019 Local DB
Hello,
Does anyone know how to patch/update the SQL Server 2019 LocalDB utilised by Microsoft AD Connect / Entra Connect?
We have identified vulnerabilities on the version of SQL 2019 LocalDB used by Microsoft Entra Connect.
The trace file in C:\ProgramData\AADConnect shows the following version:
Package=Microsoft SQL Server 2019 LocalDB , version=15.0.4138.2 (CU11)
We are attempting to update this local database to version 15.0.4415.2 (CU30), using the following package: https://www.microsoft.com/en-us/download/details.aspx?id=100809
However, when we run the package it cannot identify the SQL Server 2019 LocalDB server instance. There is a message stating: "The version of SQL Server instance Shared Component does not match the version expected by the SQL Server update. The installed SQL Server product version is 11.4.7001.0, and the expected SQL Server version is 15.0.2000.5"
The version it references is SQL Server 2012, however the logs show the database as SQL 2019 and the database instance name within the Entra Connect / AD Connect agent includes 2019.
I have attempted leaving the service running, manually starting the database instance, running as admin, and running the package via command prompt targeting the instance.
Any insight would be greatly appreciated.
Many thanks.
I had to uninstall the Microsoft SQL Server 2012 Native Client. You'll get a warning telling you that Microsoft SQL Server 2019 LocalDB relies on it but click on "Yes" when it asks if you want to continue. Once the uninstall is done, you should be able to install the latest update for Microsoft SQL Server 2019 LocalDB. This will reinstall the Microsoft SQL Server 2012 Native Client.
