SCCM 2012 – Reporting Service Role on SQL Cluster?

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.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.