Link to home
Create AccountLog in
Avatar of IT Team
IT TeamFlag 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?
Avatar of IT Team
IT Team
Flag of United States of America image

Link to home
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of Vadim Rapp
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.