Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

Troubleshooting
Research
Professional Opinions
Ask a Question
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

troubleshooting Question

Determine SQL Server Used by Azure AD Connect

Avatar of IT Team
IT TeamFlag for United States of America asked on
InstallationAzureSQL
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?
ASKER CERTIFIED SOLUTION
Avatar of IT Team
IT TeamFlag of United States of America imageIT Manager

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

Commented:
This problem has been solved!
Unlock 1 Answer and 2 Comments.
See Answers