Security Changes Required for SharePoint Timer Job

During feature activation the following error may occur:

System.Data.SqlClient.SqlException: EXECUTE permission denied on object ‘proc_putObject’, database ‘SharePoint_Config’, schema ‘dbo’

The database and schema name will reflect the SharePoint (WSS 3.0) install values.

A SharePoint timer job requires the following permissions be set on the named stored procedures within the associated SharePoint SQL server database:

Permission Store Procedure Database Role
EXECUTE proc_dropObject WSS_Content_Application_Pools
EXECUTE proc_getNewObjects WSS_Content_Application_Pools
EXECUTE proc_putClass WSS_Content_Application_Pools
EXECUTE proc_putObject WSS_Content_Application_Pools

The error is caused because WSS_Content_Application_Pools account does not have Farm Administrator privileges.

The permissions can be set from SQL Server Management Studio.

Figure 1.

During timer job execution the following error may occur.

System.UnauthorizedAccessException: Access to the path ‘C:\Documents and Settings\All Users\Application Data\Microsoft\SharePoint\Config\38090137-fe90-4ece-aab2-306f97151dc3\cache.ini’ is denied.

The path reflects the location where SharePoint (WSS 3.0) is installed.

Grant full control permission to WSS_WPG to the following directory (folder):

‘C:\Documents and Settings\All Users\Application Data\Microsoft\SharePoint’

The path reflects the application data area in use by the SharePoint (WSS 3.0) installation.

This error is caused because WSS_WPG has only Read Access in the above file path. When install SharePoint SP1 ensure WSS_WPG has Local Launch and Local Activation permissions.

Recycling IIS stops and starts SharePoint (WSS 3.0) services. It does not stop and restart any SharePoint (WSS 3.0) timer jobs. Timer jobs run outside IIS control. To recycle SharePoint (WSS 3.0) timer jobs, go to the system services dialog and restart Windows SharePoint Services Timer.

Figure 2.


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s