SharePoint Event Id 5214


Event Type: Error

Event Source: Windows SharePoint Services 3

Event Category: Databaseclip_image001

Event ID: 5214

Date: 10/16/2008

Time: 8:43:58 AM

User: N/A



Insufficient SQL database permissions for user ” in database

‘SharePoint_Config’ on SQL Server instance ‘SharePointDataBase’. Additional error information from SQL Server is included below.

The EXECUTE permission was denied on the object

‘proc_putPendingDistributionList’, database ‘SharePoint_Config’, schema ‘dbo’.

This is a known issue and can be resolved with the August 2008 cumulative update.

1. Windows SharePoint Services 3.0 hot fix package

2. SharePoint Server 2007 hot fix package

Thanks to Lambert Qin from Microsoft Online Support on Eggheadcafe

2 Replies to “SharePoint Event Id 5214”

  1. Hello All,

    I have been receiving this message and have literally tried everything i can. I have checked the following:
    1) Made sure that this account exists within SQL Server 2005 Database’s under dbOwner
    2) Under SQL Server Security this account exisits and is a part of dbCreator’s and serveradmin roles
    3) This is the account used in the IIS for the Site80 & Central Administration Control
    4) I have performed the steps mentioned in this article and made sure i am using the same account.
    5) I have installed Service Pack & WSS updates and the hotfix mentioned in this article

    But its still giving me an error. The error is that when i go to the default site of the server it gives me Error: Access Denied and then in the bottom it gives me the username i am loged on with (its the same username i have used throughout the site) and then also gives me an option to “sign in as a different user”

    Any help urgently would be very helpful.

    SPS Learner

Comments are closed.