{"id":95,"date":"2011-03-11T17:03:48","date_gmt":"2011-03-11T17:03:48","guid":{"rendered":"http:\/\/sccm.haas.se\/?p=95"},"modified":"2011-03-14T17:01:40","modified_gmt":"2011-03-14T17:01:40","slug":"error-poetry","status":"publish","type":"post","link":"http:\/\/sccm.haas.se\/?p=95","title":{"rendered":"Error poetry"},"content":{"rendered":"<p><em>An error occurred during client rendering.<br \/>\nAn error has occurred during report processing.<br \/>\nQuery execution failed for dataset &#8216;DataSet2&#8217;.<br \/>\nThe EXECUTE permission was denied on the object<br \/>\n&#8216;PowerManagementGetPowerCapabilities&#8217;, database &#8216;SMS_CEN&#8217;, schema &#8216;dbo&#8217;.<\/em><\/p>\n<p>Right, so you&#8217;re trying to view a report in Reporting Sevices that you copied from ConfigMgr and now you&#8217;re getting this. What is wrong? The SQL-account you&#8217;re\u00a0using to access the\u00a0Reporting Services database simply has insufficent\u00a0 rights. That&#8217;s what the message above is trying to tell us.<\/p>\n<p><figure id=\"attachment_177\" aria-describedby=\"caption-attachment-177\" style=\"width: 550px\" class=\"wp-caption alignnone\"><a rel=\"attachment wp-att-177\" href=\"http:\/\/sccm.haas.se\/?attachment_id=177\"><img loading=\"lazy\" class=\"size-large wp-image-177 \" title=\"anerror\" src=\"http:\/\/sccm.haas.se\/wp-content\/uploads\/2011\/03\/anerror-1024x640.png\" alt=\"\" width=\"550\" height=\"343\" \/><\/a><figcaption id=\"caption-attachment-177\" class=\"wp-caption-text\">The error in Internet Explorer<\/figcaption><\/figure><\/p>\n<p>After some trial and error I\u00a0gave my Reporting Services SQL-account rights as <em>db_datareader <\/em>and <em>smsschm_users <\/em>in the ConfigMgr database (SMS_&lt;sitecode&gt;). See screenshot below:<\/p>\n<p><a href=\"http:\/\/sccm.haas.se\/wp-content\/uploads\/SQLrights1.png\"><img loading=\"lazy\" class=\"alignnone size-medium wp-image-107\" title=\"SQLrights\" src=\"http:\/\/sccm.haas.se\/wp-content\/uploads\/SQLrights1-236x300.png\" alt=\"\" width=\"236\" height=\"300\" srcset=\"http:\/\/sccm.haas.se\/wp-content\/uploads\/SQLrights1-236x300.png 236w, http:\/\/sccm.haas.se\/wp-content\/uploads\/SQLrights1.png 784w\" sizes=\"(max-width: 236px) 100vw, 236px\" \/><\/a><\/p>\n<p>After that,\u00a0reports work great.<\/p>\n<p>\/Mathias<\/p>\n","protected":false},"excerpt":{"rendered":"<p>An error occurred during client rendering. An error has occurred during report processing. Query execution failed for dataset &#8216;DataSet2&#8217;. The EXECUTE permission was denied on the object &#8216;PowerManagementGetPowerCapabilities&#8217;, database &#8216;SMS_CEN&#8217;, schema &#8216;dbo&#8217;. Right, so you&#8217;re trying to view a report in Reporting Sevices that you copied from ConfigMgr and now you&#8217;re getting this. What is<\/p>\n<p class=\"text-right\"><span class=\"screen-reader-text\">Continue Reading&#8230; Error poetry<\/span><a class=\"btn btn-secondary continue-reading\" href=\"http:\/\/sccm.haas.se\/?p=95\">Continue Reading&#8230;<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[9,7],"tags":[14,46,13],"_links":{"self":[{"href":"http:\/\/sccm.haas.se\/index.php?rest_route=\/wp\/v2\/posts\/95"}],"collection":[{"href":"http:\/\/sccm.haas.se\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/sccm.haas.se\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/sccm.haas.se\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/sccm.haas.se\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=95"}],"version-history":[{"count":26,"href":"http:\/\/sccm.haas.se\/index.php?rest_route=\/wp\/v2\/posts\/95\/revisions"}],"predecessor-version":[{"id":109,"href":"http:\/\/sccm.haas.se\/index.php?rest_route=\/wp\/v2\/posts\/95\/revisions\/109"}],"wp:attachment":[{"href":"http:\/\/sccm.haas.se\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=95"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/sccm.haas.se\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=95"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/sccm.haas.se\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=95"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}