SharePoint Event Id 5214
Event Type: Error
Event Source: Windows SharePoint Services 3
Event Category: Database
Event ID: 5214
Date: 10/16/2008
Time: 8:43:58 AM
User: N/A
Computer: SHAREPOINTSERVER
Description:
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
[...] SharePoint Event Id 5214 [...]
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 http://technet.microsoft.com/en-us/library/cc561019.aspx 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 http://www.alpesh.nakars.com/blog/sharepoint-error-event-id-5214/
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