SharePoint Event Id 5214
Event Type: Error
Event Source: Windows SharePoint Services 3
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
- Thanks, that is quite useful!...
- Hi Guys, Any one know how to push this out to multiple ma...
- Cheers mate. tried a bunch of stuff and this worked a treat ...
- .. ] is another nice source of information on this topic..]...
- I found easier way to do so. Tools-> Options-> Mail F...
- Yeah I was wondering how to sign up for the Windows Live Hot...
- Hello, I already have the image embedded into the html si...
- make sure you do all line breaks with shift + enter and b...
- after creating a sig with the logo you want, you can open MS...
- What if there is not signature folder, I'm doing this remote...



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