Event Type: Error
Event Source: Windows SharePoint Services 3
Event Category: Database
Event ID: 5214
Date: 2/12/2013
Time: 2:51:05 PM
User: N/A
Computer: SERVERNAME
Description:
Insufficient SQL database permissions for user '' in database 'SharePoint_ConfigDBXX' on SQL Server instance 'SERVERNAME'. Additional error information from SQL Server is included below.
The EXECUTE permission was denied on the object 'proc_getNewObjects', database 'SharePoint_ConfigDBXX', schema 'dbo'.
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
----
The procedure to solve the problem follow these steps:
Open the SQL Management Studio
Locate the database that presents the problem in my case was 'SharePoint_Config'
Open the database and then Security> Roles> Database Roles
In the right part of the window, right-click the role WSS_Content_Application_Pools and click on properties
Select from the left menu option "Securables"
By clicking "Add"
Select "Specific objects" and click "OK"
Click "Object Types", select "Stored Procedures" and click "OK"
Add the stored procedures in the error in my case was the proc_GetNewObjects but it is also important to check whether the following stored procedures are added; proc_FetchDocForUpdate, proc_GetWebMetaInfo, proc_UpdateDirtyDocument, proc_UpdateListItem not I be there to add.
Click Ok to add these stored procedures
Teams stored procedures that were added and select "Execute" in the column of "Grant"
Click "Add" once again
Select "Specific objects" and click "OK"
Click "Object Types", select "views" and click "OK"
Check if the view is added UserData otherwise select to add
Click on ok to add this view
Teams eye that was added and select "Select" column of "Grant"
Click on ok to finish.
Once this procedure done mistakes of 5214 should no longer appear in the event viewer of the server.
ref: http://mundomoss.blogspot.com.au/2010/04/sharepoint-error-5214-execute.html
Event Source: Windows SharePoint Services 3
Event Category: Database
Event ID: 5214
Date: 2/12/2013
Time: 2:51:05 PM
User: N/A
Computer: SERVERNAME
Description:
Insufficient SQL database permissions for user '' in database 'SharePoint_ConfigDBXX' on SQL Server instance 'SERVERNAME'. Additional error information from SQL Server is included below.
The EXECUTE permission was denied on the object 'proc_getNewObjects', database 'SharePoint_ConfigDBXX', schema 'dbo'.
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
----
The procedure to solve the problem follow these steps:
Open the SQL Management Studio
Locate the database that presents the problem in my case was 'SharePoint_Config'
Open the database and then Security> Roles> Database Roles
In the right part of the window, right-click the role WSS_Content_Application_Pools and click on properties
Select from the left menu option "Securables"
By clicking "Add"
Select "Specific objects" and click "OK"
Click "Object Types", select "Stored Procedures" and click "OK"
Add the stored procedures in the error in my case was the proc_GetNewObjects but it is also important to check whether the following stored procedures are added; proc_FetchDocForUpdate, proc_GetWebMetaInfo, proc_UpdateDirtyDocument, proc_UpdateListItem not I be there to add.
Click Ok to add these stored procedures
Teams stored procedures that were added and select "Execute" in the column of "Grant"
Click "Add" once again
Select "Specific objects" and click "OK"
Click "Object Types", select "views" and click "OK"
Check if the view is added UserData otherwise select to add
Click on ok to add this view
Teams eye that was added and select "Select" column of "Grant"
Click on ok to finish.
Once this procedure done mistakes of 5214 should no longer appear in the event viewer of the server.
ref: http://mundomoss.blogspot.com.au/2010/04/sharepoint-error-5214-execute.html
No comments:
Post a Comment