This SharePoint tutorial, we will discuss how to fix error “cannot connect to the configuration database” in SharePoint.
When Microsoft users access SharePoint 2010/SharePoint 2013, they come across a very common error i.e. “Cannot connect to the configuration database” which means that SharePoint is unable to synchronize with the database and hence, end users cannot view it.
cannot connect to the configuration database
Before knowing how to fix cannot connect to the configuration database SharePoint error, let us understand why the error is coming.
The reason behind the error
Well, there are many reasons due to which this configuration error occurs and some of them are:
- Internet connectivity may be lost between server databases.
- It may be due to the SQL database not functioning properly.
- The installation of the service pack of SQL server application is done improperly.
- The permissions may not be granted for accessing the SQL Server database.
- The new server has not been added to the domain of SharePoint 2010.
The solution for Fixing the Error:
Before going through the procedure for resolving configuration error, first, check whether the following criteria are fulfilled or not:
- All permissions related to accessing the SQL database are granted.
- Check and validate whether the SQL database is in running mode.
- Microsoft SQL Server to be accessed is not blocked by Firewall.
If the above-mentioned criteria are not fulfilled, then we need to successfully fulfill these criteria first and check whether the error still occurs or not.
If the occurrence of error continues, then go for the below-mentioned solution for fixing the error:
For connectivity between SharePoint and Microsoft SQL server database, check whether the status of the SQL database is in running mode or not. If not then change its status to running mode, else continue with the next step.
The internet connectivity of your machine must be proper and there should be accurate mapping in between the servers involved in it.
Check and Validate whether the Internet Information Service (IIS) manager of your PCs is not in isolation mode. However, if it is in isolation mode then remove it from that mode.
If the server is newly added to the domain, then check whether it is configured properly or not by analyzing the computer management of your machine.
After completing all the above-mentioned steps and if the error still occurs, then first uninstall the pre-installed service pack of the SQL server and then again re-install it because the cause of this error may be due to improper installation of the service pack.
Here we can conclude with the fact that there are various reasons due to which ‘cannot connect to the configuration database’ error occurs in SharePoint 2010. Therefore, multiple solutions given in the content can be used to handle the situation.
You may like following SharePoint database tutorials:
- Get Content DataBase Size Using PowerShell in SharePoint 2013
- Get SharePoint content database size using PowerShell and server object model
- Find content database name for site collection using PowerShell in SharePoint 2013/2016
- SharePoint 2016 Error New-SPConfigurationDatabase some or all identity references could not be translated Supply values for parameter Credential
- Get content database sizes for all web applications in a SharePoint farm using PowerShell
- Move SharePoint databases to new SQL server
- Reporting Services Catalog Database File Existence Error while installing SharePoint 2016
- Backup and Restore content database SharePoint 2013
- Excel service to import external database using a secure store connection in SharePoint
- Data Refreshing issue Access Denied to Analysis services Database. Contact Administrator SharePoint Business Intelligence (BI) services
- Export to database failed. To export a list you must have a Microsoft SharePoint Foundation-compatible application error in SharePoint 2013
- SharePoint 2016 installation errors
- Content databases are growing too large in SharePoint 2013/2016
I hope this will be helpful to fix error cannot connect to the configuration database error in SharePoint.
I am Bijay from Odisha, India. Currently working in my own venture TSInfo Technologies in Bangalore, India. I am Microsoft Office Servers and Services (SharePoint) MVP (5 times). I works in SharePoint 2016/2013/2010, SharePoint Online Office 365 etc. Check out My MVP Profile.. I also run popular SharePoint web site SPGuides.com
Download SharePoint Online Tutorial PDF FREE!
Get update on Webinars, video tutorials, training courses etc.