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
- I am sure it can be done! :) I am a no code guy ;)...
- Can this be done with code?; For example when the webpart is...
- Fab 40 for MOSS 2010 are now available http://microsofttec...
- i was try to remove site with "Remove-SPSite http://....." ...
- I am unable to do this in Outlook2007 :( .. I have tried eve...
- Hi, I need to ask something that regard the lookup field for...
- how do I download windows live hotmail plus to gain more MB'...
- What I did was to extend the webapplication to port 80 inste...
- I have a question... If i extend the web application to the ...
- in part 11 when i submit the info i get the error "The va...
Links (11/12/2008) « Steve Pietrek - Everything SharePoint said,
Wrote on November 13, 2008 @ 12:15 pm
[...] SharePoint Event Id 5214 [...]
SPS Learner said,
Wrote on February 24, 2009 @ 11:19 pm
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