We are getting frequent errors in event viewer for SharePoint server. It occurs in every 1 minute interval.
The exact error text is as follows:
" Insufficient SQL database permissions for user '' in database 'SharePoint_Config' on SQL Server instance 'SQLDBSERVER'. Additional error information from SQL Server is included below.
The EXECUTE permission was denied on the object 'proc_dropObject', database 'SharePoint_Config', schema 'dbo'. "
The steps which we have followed before this error starts generating are:
1.We had run one patch named:
a.hotfix(package: February 6, 2007, Wss-kb931636-fullfile-x86-glb.exe)
2.We ran SharePoint Configuration Wizard.
3.After that the system started logging the error in event viewer.
The error indicates that the Execute permission is missing for a few system procedures for System user. Name of the Stored Procedures and relevant database name are as below:
proc_putObject (Sharepoint_config database)
proc_GetListFields (SharePoint_AdminContent_1f46ecd5-631c-4595-8852-5e949c64236b database)
When we explicitly give Execute permission to above stored procedures then the error stops logging in Event Viewer.
This error also stops the SharePoint workflow from triggering normally. It holds the workflow in "Starting" state only.
We are using Server Farm topology so we have both SQLServer and SharePoint Server on different server machines.
Can anyone please guide us as to why we are getting this error. Because of SharePoint Configuration Wizard or because of the patch that we ran? and how to get rid of this issue?