This is really a part of a longer story but I wanted to get this bit documented before I lost track of which error occurred when.
I was following this blog reference in order to fix something else but had another error occur mid-process.
Basically the instructions are:
- Disable Publishing in the site
- Disable Publishing in the site collection
- Enable Publishing in the site collection
- Enable Publishing in the site.
The error occurred when trying step #3 to re-enable the publishing.
The EXECUTE permission was denied on the object ‘proc_putObject’, database ”, schema ‘dbo’. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Bool…..
…..lingJobDefinitions(SPSite site)
It appears that the Disable option is not permission controlled while the enable option is. What I discovered was that while the service account had permissions on most of the sharepoint db’s it was not dbo_owner on the config DB. I found this using SQL Management tools and made the appropriate change to add db_owner permissions.
I could then re-enable the Publishing service.