Saturday, November 2, 2013

SharePoint Cannot connect to the configuration database Error

Problem: Users received "Cannot connect to the configuration database" error when trying to acces SharePoint sites!
Cannot connect to the configuration database Error

Reason: SQL Server services were stopped during a patch installation. (In an another case, SQL Server service stopped due to disk space issue!).

Solution: Start SQL Server Service!
  1. Go to SQL Server Configuration Manager
  2. Right click on "SQL Server (MSSQLSERVER)" Service which is in "Stopped" State, and Start it.
start sql server service for sharepoint
You can do the same with Services console. Go to Run >> Services.msc >> start the MSSQLServer Service!
But wait! There could be some other reasons for "Cannot connect to the configuration database" or "Unable to connect to database. Check database connection information and make sure the database server is running" error in SharePoint, such as:
  • Network connectivity issues between SharePoint Web/App Servers and Database Server. Make sure your SharePoint servers are able to communicate with SQL Server by pinging/NSLookup. Also make sure no firewall rules are blocking your connections.
  • The SharePoint service account used in App Pool doesn't has enough access to SQL Server! Make sure your AppPool account has: Security Administrator & Database Creator rights on SQL Server. It also occurs when your service account password expire.
  • Simply a Server Reboot also works sometimes!
  • SharePoint database(s) may be in Offline mode, bring them Online from database properties!

You might also like:
SharePoint Usage Reports
Usage reports, collaboration and audit for SharePoint.
Document SharePoint Farm
Automatically generate SharePoint documentation.

Check out these SharePoint products:

No comments :

Post a Comment

Please Login and comment to get your questions answered!

You might also like:

Related Posts Plugin for WordPress, Blogger...