Answered by:
EXECUTE permission was denied on the object 'proc_putObject'?

Question
-
I use the following code to update web.config it give me the following error:
SPFarm
.Local.Services.GetValue<SPWebService>().ApplyWebConfigModifications();
The error is as follows, please advise me how to solve this problem?
The EXECUTE permission was denied on the object 'proc_putObject', database 'SharePoint_Config', schema 'dbo'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Microsoft.SharePoint.Utilities.SqlSession.ExecuteNonQuery(SqlCommand command)
at Microsoft.SharePoint.Administration.SPConfigurationDatabase.StoreObject(SPPersistedObject obj, Boolean storeClassIfNecessary, Boolean ensure)
at Microsoft.SharePoint.Administration.SPConfigurationDatabase.PutObject(SPPersistedObject obj, Boolean ensure)
at Microsoft.SharePoint.Administration.SPPersistedObject.Update()
at Microsoft.SharePoint.Administration.SPWebApplication.ApplyWebConfigModifications()
at Microsoft.SharePoint.Administration.SPWebService.ApplyWebConfigModifications()
at DebugConfigFeature.FeatureReceiver.AddConfigurationToWebConfig(SPWebApplication app, Boolean removeModification)
at DebugConfigFeature.FeatureReceiver.AddOrRemoveHandler(SPFeatureReceiverProperties properties, Boolean removeModification)
at DebugConfigFeature.FeatureReceiver.FeatureActivated(SPFeatureReceiverProperties properties)
at Microsoft.SharePoint.SPFeature.DoActivationCallout(Boolean fActivate, Boolean fForce)
at Microsoft.SharePoint.SPFeature.Activate(SPSite siteParent, SPWeb webParent, SPFeaturePropertyCollection props, Boolean fForce)
at Microsoft.SharePoint.SPFeatureCollection.AddInternal(Guid featureId, SPFeaturePropertyCollection properties, Boolean force, Boolean fMarkOnly)
at Microsoft.SharePoint.SPFeatureCollection.Add(Guid featureId)
at Microsoft.SharePoint.WebControls.FeatureActivator.BtnActivateFeature_Click(Object objSender, EventArgs evtargs)
at System.Web.UI.WebControls.Button.OnClick(EventArgs e)
at System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument)
at System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument)
at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument)
at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData)
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
Thanks.Friday, October 3, 2008 6:40 PM
Answers
-
Hi Kevin,
Make sure your application pool user has enough rights to access SQL / SharePoint configuration database
http://social.msdn.microsoft.com/Forums/en-US/sharepointdevelopment/thread/6c2d8a47-0cf5-49ce-82e9-100363170fc7/
James
- James Tsai | wwww.jamestsai.net | SharePoint Blog- Marked as answer by Kevin Ding Wednesday, October 8, 2008 5:45 PM
- Unmarked as answer by Kevin Ding Wednesday, October 8, 2008 5:45 PM
- Marked as answer by Kevin Ding Wednesday, October 8, 2008 5:45 PM
Wednesday, October 8, 2008 2:51 AM
All replies
-
Hi Kevin,
Make sure your application pool user has enough rights to access SQL / SharePoint configuration database
http://social.msdn.microsoft.com/Forums/en-US/sharepointdevelopment/thread/6c2d8a47-0cf5-49ce-82e9-100363170fc7/
James
- James Tsai | wwww.jamestsai.net | SharePoint Blog- Marked as answer by Kevin Ding Wednesday, October 8, 2008 5:45 PM
- Unmarked as answer by Kevin Ding Wednesday, October 8, 2008 5:45 PM
- Marked as answer by Kevin Ding Wednesday, October 8, 2008 5:45 PM
Wednesday, October 8, 2008 2:51 AM -
Add the Web Application Pool identity to the farm admin group.
Do an IISReset first, before trying the action again.
Friday, July 2, 2010 12:00 PM