Expert Advice

KQP_Connection_To_SP_DB  
Situation Description
Suggested Actions
Situation Description

Unable to connect SharePoint database.

 

Suggested Actions



Problem Description:

Windows SharePoint Services (or SharePoint Foundation for SharePoint Server 2010) could not connect to the SharePoint database.

Possible Cause:

  1. The computer running SQL Server was turned off.
  2. The SQL Server service was paused.
  3. Network connectivity problems.
  4. The service account used to initialize the connection lacks permissions on the SharePoint database.
Advice:
  1. Start the computer running SQL Server, if it is turned off.
  2. Start the SQL Server service.
  3. Check if there is any network connectivity problem
  4. Check if service account has enough permission for connecting to SharePoint database.
Note: Windows SharePoint Services (or SharePoint Foundation for SharePoint Server 2010) uses SQL Server to store most of the content for the website as well as configuration settings. For example, all pages in the site, files in document libraries, files attached to lists, and information in lists are stored in the content database, and security and permission settings along with other configuration settings are stored in the configuration database in SQL Server.

 

Copyright IBM Corp. 2005, 2010 All Rights Reserved US Government Users Restricted Rights - Use, duplication or disclosure restricted by GSA ADP Schedule Contract with IBM Corp. Contact IBM