locked
SCCM 2012 on a SQL 2012 cluster w/ SSRS 2012 RRS feed

  • Question

  • I'm working on architecting a new design for our SCCM 2012 deployment.  We're going to wipe out our 2007 install and start fresh.  I'm wondering if SCCM 2012 can be configured on a 3 node SQL 2012 cluster on it's own instance w/ the correct collation of course?  How would I get SSRS working with that if our SSRS server is a seperate physical server from our SQL cluster?  I setup reporting in my test environment where everything is on the same machine, but when I tried to point to a different location for SSRS there was only a drop down box that was empty.  Only when I installed SSRS locally was I allowed to proceed with installing the reporting role.  Any ideas?
    Friday, February 8, 2013 9:24 PM

All replies

  • You can install SQL reporting Services on a seperate box, the database and SSRS Works just fine on two different boxes. If you can't see the instance in the drop Down then check that Reporting services and SQL are running the same version, and that you have local administrative permissions on the SQL reporting server.

    Kent Agerlund | My blogs: blog.coretech.dk/kea and SCUG.dk/ | Twitter: @Agerlund | Linkedin: Kent Agerlund | Mastering ConfigMgr 2012 The Fundamentals

    Saturday, February 9, 2013 9:36 AM
  • Maybe a better question would be, how does SCCM discover the SQL reporting server to populate the drop down?
    Monday, February 11, 2013 4:17 PM
  • Maybe a better question would be, how does SCCM discover the SQL reporting server to populate the drop down?

    It queries WMI to gather this data.

    http://www.enhansoft.com/

    Monday, February 11, 2013 4:45 PM
  • Queries WMI of which server?  That may be a stupid question, I apologize.
    Monday, February 11, 2013 8:28 PM
  • It would query the WMI on your SSRS server.


    http://www.enhansoft.com/

    Tuesday, February 12, 2013 1:10 PM
  • How would it query WMI on our SSRS server if we haven't specified where our SSRS server is?  The issue is the drop down to specify the location is blank when trying to add the Reporting Role to SCCM.
    Tuesday, February 12, 2013 2:58 PM
  • When you get to this point (screenshot), it queries WMI to populate the Reporting Services Instance.  (red arrow).. We both on the same page??? or am I still off-base?


    http://www.enhansoft.com/

    Tuesday, February 12, 2013 3:14 PM
  • Same page yes.  However that "Reporting Services server instance:" is blank for me.  I want to enter in a seperate SSRS URL since our reporting server is on a seperate physical box.  Since I can't enter a URL in that field, how do I get SCCM reporting on our seperate SSRS server?  The database is installed on the local server, do I also need to install SSRS on the local SCCM server in this case or can I have it pointed to a different SSRS URL?
    Tuesday, February 12, 2013 4:27 PM