{"id":65,"date":"2011-03-11T16:28:17","date_gmt":"2011-03-11T16:28:17","guid":{"rendered":"http:\/\/sccm.haas.se\/?p=65"},"modified":"2011-12-07T15:19:16","modified_gmt":"2011-12-07T15:19:16","slug":"reporting-services-configuration-can-be-tricky","status":"publish","type":"post","link":"http:\/\/sccm.haas.se\/?p=65","title":{"rendered":"Reporting Services configuration can be tricky…"},"content":{"rendered":"

…very tricky indeed. I had no idea how complicated it can be until today.<\/p>\n

In this installation of SCCM 2007 R2 (in my case R3) with SP2 – Configuration options where greyed out in the “Copy Reports Wizard” as well as when you\u00a0right click the Reporting Services Server icon below Reports in the SCCM-console.<\/p>\n

\"\"<\/a><\/p>\n

According to Microsoft<\/a> this can happen if you run more than two instances of SQL Reporting Services on the same machine and\u00a0that’ll make ConfigMgr confused\u00a0since it\u00a0automatically selects\u00a0the default instance of Reporting\u00a0Server\u00a0through WMI.\u00a0I’m pretty sure\u00a0 this issue happens\u00a0if you choose “Install but do not configure the report server” during the SQL 2008 installation instead of “Install the native mode configuration”. I have to test this in the lab but I’m guessing the SQL RPS instance never gets created if you don’t configure RPS\u00a0and therefore SCCM can’t find it.<\/p>\n

If you want to fix\u00a0 this, all you need to do is to open Reporting Services Configuration Manager and configure RPS manually.
\n
\n\"\"<\/p>\n

\"\"<\/a>
The network account works fine but I believe that Local System is more secure.<\/figcaption><\/figure><\/p>\n

\"\"<\/a>
Here you need to create the RP-database and use an account to access it.<\/figcaption><\/figure><\/p>\n

\"\"<\/a>
This is only necessary if you want scheduled reports delivery by mail as an option instead of file share only.<\/figcaption><\/figure><\/p>\n

\"\"<\/a>
No need to configure this.<\/figcaption><\/figure><\/p>\n

I assume reinstalling reporting services in native mode should also help if you run into this issue.<\/p>\n

Did you find this helpful? Please leave a comment!<\/p>\n

\/Mathias<\/p>\n","protected":false},"excerpt":{"rendered":"

…very tricky indeed. I had no idea how complicated it can be until today. In this installation of SCCM 2007 R2 (in my case R3) with SP2 – Configuration options where greyed out in the “Copy Reports Wizard” as well as when you\u00a0right click the Reporting Services Server icon below Reports in the SCCM-console. According<\/p>\n

Continue Reading… Reporting Services configuration can be tricky…<\/span>Continue Reading…<\/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\/65"}],"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=65"}],"version-history":[{"count":64,"href":"http:\/\/sccm.haas.se\/index.php?rest_route=\/wp\/v2\/posts\/65\/revisions"}],"predecessor-version":[{"id":83,"href":"http:\/\/sccm.haas.se\/index.php?rest_route=\/wp\/v2\/posts\/65\/revisions\/83"}],"wp:attachment":[{"href":"http:\/\/sccm.haas.se\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=65"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/sccm.haas.se\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=65"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/sccm.haas.se\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=65"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}