{"id":158,"date":"2009-12-11T09:19:20","date_gmt":"2009-12-10T22:19:20","guid":{"rendered":"http:\/\/howden.net.au\/thowden\/?p=158"},"modified":"2009-12-11T09:19:20","modified_gmt":"2009-12-10T22:19:20","slug":"sharepoint-error","status":"publish","type":"post","link":"https:\/\/howden.net.au\/thowden\/2009\/12\/sharepoint-error\/","title":{"rendered":"Sharepoint error: EXECUTE permission was denied on the object ‘proc_putObject’"},"content":{"rendered":"

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.<\/p>\n

I was following this blog reference<\/a> in order to fix something else but had another error occur mid-process.<\/p>\n

Basically the instructions are:<\/p>\n

    \n
  1. Disable Publishing in the site<\/li>\n
  2. Disable Publishing in the site collection<\/li>\n
  3. Enable Publishing in the site collection<\/li>\n
  4. Enable Publishing in the site.<\/li>\n<\/ol>\n

    The error occurred when trying step #3 to re-enable the publishing.<\/p>\n

    The EXECUTE permission was denied on the object ‘proc_putObject’, database ”, schema ‘dbo’.\u00a0\u00a0 at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Bool…..<\/span><\/p>\n


    \n<\/span><\/p>\n

    …..lingJobDefinitions(SPSite site)<\/span><\/p>\n


    \n<\/span><\/p><\/blockquote>\n

    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.<\/p>\n

    I could then re-enable the Publishing service.<\/p>\n","protected":false},"excerpt":{"rendered":"

    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 […]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[15],"tags":[],"class_list":["post-158","post","type-post","status-publish","format-standard","hentry","category-sharepoint"],"_links":{"self":[{"href":"https:\/\/howden.net.au\/thowden\/wp-json\/wp\/v2\/posts\/158","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/howden.net.au\/thowden\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/howden.net.au\/thowden\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/howden.net.au\/thowden\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/howden.net.au\/thowden\/wp-json\/wp\/v2\/comments?post=158"}],"version-history":[{"count":0,"href":"https:\/\/howden.net.au\/thowden\/wp-json\/wp\/v2\/posts\/158\/revisions"}],"wp:attachment":[{"href":"https:\/\/howden.net.au\/thowden\/wp-json\/wp\/v2\/media?parent=158"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/howden.net.au\/thowden\/wp-json\/wp\/v2\/categories?post=158"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/howden.net.au\/thowden\/wp-json\/wp\/v2\/tags?post=158"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}