SharePoint 2010 Cookbook: “Cannot Connect to the Configuration Database” Error

Challenge:

When you try to view your SharePoint site and receive the error message, "Cannot connect to the configuration database," how do you resolve the problem?

 

Solution

On the server farm, SharePoint connects to SQL Server through a domain account, so checking the network and user in AD are the most important things you need to do first. Never assume that everything is working correctly on the server farm; the "cannot connect to the configuration database" error is most often a result of an issue with the domain user account.

Follow these step to check whether the domain user account is working correctly or not.

Assume that the domain account which is used to connect to the configuration database is "MyDomainsqlaccount."

After running the SharePoint configuration wizard, this account is added into some groups in User People & Groups. Let's check your account on that.

Go to Run and type compmgmt.msc then press Enter. When the Computer Management window opens, expand the User People & Groups node, and click the Groups item on the tree. On the right-hand side, all groups will be listed, so double-click on the group named "WSS_ADMIN_WPG," and you will see an account like:

 

Sometimes, you will see this:

 

Yes, the account which is needed to connect to the database is not working correctly, which is triggering the error message. The good news is that to solve this problem, you don't need to change or reconfigure anything on your server farm, or on any server which has joined the farm. Just remove the server which hosted Central Admin out of your domain, join it to your domain again, and everything will be solved.

Good luck to you.

 

Notes

  • This issue occurs often on a server which has been newly added to the domain. If you are working on a single SharePoint Server, you can check out the following Microsoft KBs in the "See Also" section below.
  • This issue, and the fix described above, is not specific to SharePoint 2010 sites, but applies to all instances of SharePoint.

 

See Also:

SharePoint Online

The cloud parts are functional components that extend your SharePoint Online environment in Microsoft 365.

Supports Classic and Modern sites for SharePoint Online/Microsoft 365

SharePoint

Top SharePoint Online Products

Experience greater power and savings by bundling our SharePoint apps and cloud parts.


Calendar Plus


Chart Plus


Knowledge Base


Project Management Central


Simple List Search

 

On-Premises Only

These web parts extend SharePoint beyond its out-of-the-box capabilities by tailoring it to your requirements with Bamboo Solution’s growing portfolio of SharePoint Web Parts.

SharePoint 2013, 2016, 2019 – Classic Pages Only

SharePoint

Top On-Premises Only Products

Experience greater power and savings by bundling our SharePoint apps and web parts.


Calendar Plus


Data Viewer


Password Change


Password Expiration


Password Reset

 

Our team of Microsoft 365 experts help you get the most out of your Microsoft technology, we have the best Microsoft 365 talent to streamline your organization.

Streamline Your Department

We Have What You Need

Bamboo Solutions

About


Blogs


Webinar & Events


Twitch


Culture & Diversity

 

 

Bamboo Solutions

Tools


Resources


Bamboo Installer

 

Featured Services

SharePoint Health Check

A SharePoint Health Check will identify the causes of issues and risks associated with your specific environment, and is custom tailored to provide you with the best recommendations to optimize your SharePoint environment.

SQL Health Check

Document recommendations relating to performance, stability, availability, or a specific focus you request of your SQL Server database instances.

My SharePointXperts

The truth is that each SharePoint skill may not be a full time job for many organizations, and it is nearly impossible for one person to do everything you need – so augment your team with SharePointXperts; providing the skill sets you need when you need them!