Microsoft Windows Tricks

Ideal way to overcome Error “Cannot connect to the configuration database”

Cannot connect to the configuration database

MS SharePoint – a collection of SQL Server and SharePoint Server provides you with one such platform where you can easily exchange and process information wide across various departments of an organization. Researches done by many experts have also shown that employees of any organization on an average spend about 30 % of their day searching for data and information. However, eliminating such drag on productivity gets easier with SharePoint as it provides search functionality to find the information. Moreover, SharePoint allows you to create websites for use within company’s Intranet as per requirement. Performing any such task is not achievable by any other server developed by SharePoint. In fact, you all must be well aware of the fact that the SharePoint SQL Server helps organizations in performing many tasks of seamless collaboration.

Cannot connect to the configuration database while connecting to a Windows SharePoint Services 2.0 website

However, these SharePoint databases are also very much prone of getting corrupt. At times your SharePoint database that contains all your organizational data gets corrupted restricting user to access content of the database. Talking about error, let us consider the situation where while trying to connect to a Microsoft Windows SharePoint Services 2.0 website, you unfortunately receive an error message that state:

“Cannot connect to the configuration database”

Now, such sort of problem arises when one of the following conditions gets true:

  • SQL database has stopped running.
  • The account used by the application pool does not have the right authority to the SQL Server database.
  • Network connectivity has got disturbed between the Windows SharePoint Services server and the Microsoft SQL Server.

However, you don’t have to worry as there is a proper way to tackle such issue successfully. You can apply different methods.

Method 1: Verifying whether the SQL database is running or not

In order to verify if SQL database is running or not, you just got to follow the steps mentioned below:

1. Click Start, point to Programs, point to Administrative Tools, and then click Services.

2. Locate the MSSQLSERVER service, from the list of services.

Note This service may also be listed as MSSQL$SHAREPOINT.

3. Make sure you note the value of the Status column. If the Status column lists Started, the database server is running. But in case, the Status column remains empty, then it clearly indicates that the database server is not running.

Method 2: Verify that IIS is not running in IIS 5.0 isolation mode

1 Click Start, point to Programs, point to Administrative Tools, and after that click Internet Information Services (IIS) Manager.

2 Right-click the server name, and then expand the local computer.

3 After this you have to right-click on Web Sites, and then click on Properties.

4 On the Service tab, clear the Run WWW service in IIS 5.0 isolation mode check box, and then click OK.

5 To start the WWW service, click Yes.

Cannot connect to the configuration database

Now, even after performing various verifications, if you not able to find out the right solution then the best option you can have is usage of a third party SharePoint recovery tool like Kernel for SharePoint Server. This is the most remarkable database recovery software that has got ability to restore files, documents and websites from SharePoint database. The utility is very well integrated with Raw File Recovery and Live SQL instance mode, that enables you carry out instant recovery. One can operate the software easily with MS SharePoint Server 2007/ 2010/2013 and at the same time the tool is also compatible with MS SQL Server 2000/ 2005/ 2008, 2008 r2 and 2012. Without any second thought, one can rely on this software as it is very beneficial in almost every condition.

Please share this Article with your friends on Facebook as well as Google+, also subscribe to our mail list so that you will not miss out any future post and Don’t forget to comment below.

Please Share:

About the author

Harshil Barot

Harshil Barot is a Computer Geek, Internet Entrepreneur, Blogger, Day Dreamer, Business Guy, Fitness Freak, Music Lover and Digital Marketing Specialist. He also helps companies to grow their online businesses. At Just Web World he Writes about Blogging, WordPress, SEO, Business, Technology and Computer Tips and Tricks.

Leave a Comment