Friday, April 15, 2011

System.Data.SqlClient.SqlException while installing SPJob during Feature activation

Recently we came across following exception while installing SPJob during Feature installation. System.Data.SqlClient.SqlException: The EXECUTE permission was denied on the object 'proc_putObject', database 'SharePoint_Config', schema 'dbo'.

Reason: The scope of the feature was "Web". In fact the same exception will occure if you define the scope of the feature as "Site".

Solution: Define the scope of the feature as "Web Application".

No comments:

Post a Comment