{"id":1542,"date":"2014-08-14T15:29:28","date_gmt":"2014-08-14T13:29:28","guid":{"rendered":"http:\/\/sccmfaq.wordpress.com\/?p=1542"},"modified":"2014-08-14T15:29:28","modified_gmt":"2014-08-14T13:29:28","slug":"sccm-2012-reporting-service-role-on-sql-cluster","status":"publish","type":"post","link":"https:\/\/blog.hosebei.ch\/?p=1542","title":{"rendered":"SCCM 2012 &#8211; Reporting Service Role on SQL Cluster?"},"content":{"rendered":"<p>Hey, here&#8217;s Martin again, it&#8217;s been quite while since my last blog post. This one is just to help someone, which is looking for this Information, as I was and nowhere could find.<\/p>\n<p>Imagine that you have a customer who has decided to run the SCCM Database on a SQL Cluster. This is a good solution if you want to get the Advantages of a HA-Infrastructure. But please keep in mind, that you can&#8217;t install the reporting service role on the same SQL Cluster:<!--more--><\/p>\n<blockquote><p>Site system roles are not supported on an instance of a Windows Server cluster. The only exception to this is the site database server.\n<\/p><\/blockquote>\n<p>From: http:\/\/technet.microsoft.com\/en-us\/library\/gg682077.aspx<\/p>\n<p>That means, you can install the SQL Reporting Services on the SQL Cluster and you can install multiple Reporting Service role to get a redundant reporting infrastructure, but you can&#8217;t get the redundancy through the SQL Cluster alone.<br \/>\nWhen you installing the reporting Service role on the SQL Cluster Members, make sure SCCM will not install the necessary files on a clustered volume by using the &#8220;no_sms_on_drive.sms&#8221; files.<\/p>\n<p>Hope this helps.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Hey, here&#8217;s Martin again, it&#8217;s been quite while since my last blog post. This one is just to help someone, which is looking for this Information, as I was and nowhere could find. Imagine that you have a customer who has decided to run the SCCM Database on a SQL Cluster. This is a good [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[19],"tags":[],"class_list":["post-1542","post","type-post","status-publish","format-standard","hentry","category-general"],"_links":{"self":[{"href":"https:\/\/blog.hosebei.ch\/index.php?rest_route=\/wp\/v2\/posts\/1542","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.hosebei.ch\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.hosebei.ch\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.hosebei.ch\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.hosebei.ch\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1542"}],"version-history":[{"count":0,"href":"https:\/\/blog.hosebei.ch\/index.php?rest_route=\/wp\/v2\/posts\/1542\/revisions"}],"wp:attachment":[{"href":"https:\/\/blog.hosebei.ch\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1542"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.hosebei.ch\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1542"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.hosebei.ch\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1542"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}