Expert Advice

KQP_Insufficient_DB_Permission  
Situation Description
Suggested Actions
Situation Description

Insufficient SQL Server database permissions.

 

Suggested Actions



Problem Description:

Service account specified in Windows SharePoint Services (or SharePoint Foundation for SharePoint Server 2010) has insufficient privileges in SharePoint database.

Possible Cause:

  1. During deployment insufficient privileges are granted in the SharePoint database to the service account specified in Windows SharePoint Services (or SharePoint Foundation for SharePoint Server 2010).
Advice:
  1. Ensure that service account, which is used by Windows SharePoint Services (or SharePoint Foundation for SharePoint Server 2010), has sufficient permissions in the SharePoint database.
Note: Windows SharePoint Services (or SharePoint Foundation for SharePoint Server 2010) uses a service account to communicate with the database on behalf of a user request. This service account can be either a specific user name and password (domain name and password) or a predefined system account, such as Local System or Network Service.

 

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