Hey, here’s Martin again, it’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 solution if you want to get the Advantages of a HA-Infrastructure. But please keep in mind, that you can’t install the reporting service role on the same SQL Cluster:
Site system roles are not supported on an instance of a Windows Server cluster. The only exception to this is the site database server.
From: http://technet.microsoft.com/en-us/library/gg682077.aspx
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’t get the redundancy through the SQL Cluster alone.
When 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 “no_sms_on_drive.sms” files.
Hope this helps.