How to Repair the ADSync SQL Server Components

In the past 3 weeks we’ve had ADSync suddenly fall over at 5 of our customers.

I found that the ADSync service would not run, even if manually started the service start request would time out.

In event viewer I found the following:

The error indicates that there is an issue with the SQL Components of the ADSync service. Unfortunately we can’t directly interact with the SQL Server instance for ADSync, however, I did find a way to repair the components.

First, navigate to the following path:

C:\Program Files\Microsoft Azure Active Directory Connect\SetupFiles

Run each of the 3 MSI Files once, choosing the Repair option during the Installation Wizard.

SqlCmdLnUtils.msi

SqlLocalDB.msi

SqlNCli.msi

The server may need a reboot, but after the ADSync service should hopefully be able to be started