EXECUTE permission denied on object 'proc_putObject', database 'SharePoint_Config', schema 'dbo'.]


Am getting following error when i try to configure the web parts. Any help would be appreciated..thanks


wowarjuna wrote Sep 22, 2008 at 5:09 AM

In addition...I have setup the same set of web parts in my development machine without any errors...I am getting this issue in my live server..thanks

badajoz wrote Oct 15, 2009 at 11:11 PM

I have the same issue.

wrote Oct 15, 2009 at 11:11 PM

badajoz wrote Oct 20, 2009 at 3:31 AM

I believe that I've tracked the problem down the fact that ESPConnectionConfig does not perform the write of the configuration value using elevated privileges. Instead it is asking the AppPool account to write to the config database which it is not allowed to do in a farm environment which has been setup according to the best practice specified at http://technet.microsoft.com/en-au/library/cc263445.aspx (Plan for administrative and service accounts (Office SharePoint Server)). See "Application pool identity" = "The user account that the worker processes that service the application pool use as their process identity. This account is used to access content databases associated with the Web applications that reside in the application pool."

Most people's development enviroments probably all use the one account and hence work... we use farm build scripts that create development like production and set the security the same as a farm.

I try and remember to post a code fix when I have made one.

wrote Feb 13, 2013 at 11:22 PM