Avatar of IT Team
IT Team
Flag for United States of America asked on

Determine SQL Server Used by Azure AD Connect

A previous admin set up our Azure AD Connect service and we are now seeing sync errors stating the below issue.


"BAIL: MMS(8292): ..\ManagedSyncRulesEngine.cpp(57): 0x80231362 (An error occured during synchronization of the object.): Error during initialization of the sync engine: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 50 - Local Database Runtime error occurred. Cannot get a local application data path. Most probably a user profile is not loaded. If LocalDB is executed under IIS, make sure that profile loading is enabled for the current user.)


The sync errors have been occurring for about a week and the server running the sync service has been up for much longer than that.  It appears the AD Connect installation is a custom one but it was not documented.  I say it is custom because there is no evidence of SQL Server Express being installed on the server and my understanding is a local SQL Server Express installation is part of the standard/express AD Connect installation.  Is there a way to check the configuration to determine where Azure AD Connect is looking for its SQL Server connection?
SQLInstallationAzure

Avatar of undefined
Last Comment
Vadim Rapp

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
IT Team

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Vadim Rapp

This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.
rwheeler23