SharePoint – resolving error – “Cannot connect to the configuration database.”

SharePoint - Cannot connect to configuration database
SharePoint - Cannot connect to configuration database

Hi All,

Greetings for the day 🙂 LIFE IS BEAUTIFUL 🙂

SharePoint migration continues 🙂 Today new issue and solution.

Issue : Central Admin is not opening. Showing an error – “Cannot connect to the configuration database.”

Fig : SharePoint WFE – error – Cannot connect to the configuration database.
  • My initial guess was AppPool – Verified app pool its started
Fig : SharePoint WFE – Verifying Central Admin app pool
  • Then my next thought – lets run “SharePoint Products Configration Wizard” and then try to open Central Admin again but no luck 🙁 following error came
Fig : SharePoint WFE – Running “SharePoint Products Configuration Wizard”
  • Then next step is SharePoint developers best friend – ULS
  • Verified the respective logs and found below error –

Resource id to be retrieved is FarmIsJoinedFailureWhileUsingUICanOnlyDisconnect for language English (United States)
07/08/2021 01:17:44 1 INF Resource retrieved id FarmIsJoinedFailureWhileUsingUICanOnlyDisconnect is Failed to detect if this server is joined to a server farm. Possible reasons for this failure could be that you no longer have the appropriate permissions to the server farm, the database server hosting the server farm is unresponsive, the configuration database is inaccessible or this server has been removed from the server farm. To diagnose this problem further, review the extended error information located at {0}. If this problem persists, choose to disconnect from the server farm. After disconnecting, run the wizard again to create or connect to an existing server farm.

Issue / Error :

  • After looking at exception from ULS and error dialog from SharePoint Products Configuration Wizard, we found that our database server is not accessible. We couldnt connect to the database server

Solution : On database server SQL server services where stopped. Just restarted those services and database server is back in business.

Opened Central Admin and it worked like charm 🙂

Thanks for reading 🙂

Enjoy the beautiful life 🙂 Have a FUN 🙂 HAVE A SAFE LIFE 🙂 TAKE CARE

Prasham Sabadra

LIFE IS VERY BEAUTIFUL. ENJOY THE WHOLE JOURNEY :) Founder of Microsoft 365 Junction, Speaker, Author, Learner, Developer, Passionate Techie. Certified Professional Workshop Facilitator / Public Speaker. Believe in knowledge sharing. Around 20+ years of total IT experience and 17+ years of experience in SharePoint and Microsoft 365 services Please feel free me to contact for any SharePoint / Microsoft 365 queries. I am also very much interested in behavioral (life changing) sessions like motivational speeches, Success, Goal Setting, About Life, How to live Life etc. My book - Microsoft 365 Power Shell hand book for Administrators and Beginners and 100 Power Shell Interview Questions - https://www.amazon.in/Microsoft-Administrators-Beginners-Interview-Questions/dp/9394901639/ref=tmm_pap_swatch_0?_encoding=UTF8&qid=1679029081&sr=8-11

You may also like...

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Discover more from Microsoft 365

Subscribe now to keep reading and get access to the full archive.

Continue reading