troubleshooting Question

Determine SQL Server Used by Azure AD Connect

Avatar of IT Team
IT TeamFlag for United States of America asked on
2 Comments1 Solution502 ViewsLast Modified:
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?
IT Team
IT Manager

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 2 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros