We have Azure AD Connect successfully installed on a Windows 2012 R2 server and have been running it for several years.
Recently the MICROSOFT AZURE AD SYNC service stopped working.
The EventID was 6219.
"The service was unable to start because a connection to the SQL Server could not be established."
Unable to get the service to start, we uninstalled Azure AD Connect and attempted to reinstall it. No matter what method we used (Express or Custom with a domain service account), the install always failed with the following:
EventID 906
"SynchronizationServiceSetupTask:EnableADSyncBootstrapLocalDBInstance operation failed"
While Microsoft researched this further, I mentioned the issue to another Admin who manages security on our systems. He had recently set the system to best practices, including disabling TLS 1.0.
After enabling TLS 1.0 and restarting, I was able to successfully install Azure AD Connect and setup the sync schedule.
As a test, after the first sync cycle, we disabled it again and restarted. Sure enough, the MICROSOFT AZURE AD SYNC service would not start. Re-enabled it, restarted, and the service started as expected.
Just food for thought. This was NOT one of the troubleshooting steps my Microsoft Technician had on his list.