Thursday, June 21, 2012

Install SQL Server Reporting Services and the Reporting Services Role on SCCM 2012

Mostly posting for my own notes. This post lists step-by-step instructions on how to install MS SQL Server Reporting Services and adding the Reporting Services role on SCCM 2012
Keep in mind - Some settings that I list below could be different from your network or situation and may not necessarily apply to best practices.

Install SQL Server Reporting Services and the Reporting Services Role on SCCM

  1. Run SQL Setup from iso
  2. Add Features to an existing instance of SQL Server 2008 R2
    1. Choose MSSQLSERVER
  3. Feature Selection
    1. [x] Reporting Services
    2. For this feature, I could not specify the D: drive to install, this option was greyed out
  4. Service Accounts
    1. Choose SYSTEM (add other accounts later)
  5. (o) Install, but do not configure the report server (other options were greyed out)
  6. Next til finished

Login as payneb\Administrator and Open “Reporting Services Configuration Manager” and connect to database

  1. Verify service has started
    1. Check SQL Server Instance Product Version, should read “10.50.2500.0”
    2. If reads “10.50.1600”, then you need to reinstall SQL 2008 R2 SP1, otherwise the Reporting Services role in SCCM will NOT WORK!!!!
      2. An explanation is provided here:
  2. Database tab
    1. Change database
    2. Create a new report server database
    3. Database Name: ReportServer  (go w/ defaults)
      1. (o) Native Mode
    4. Finish
  3. Still logged in as payneb\Administrator, go to http://systemcenter/Reports (Use IE)
    1. Click on Site Settings
    2. Security tab > Add New Role Assignment as needed
      1. Add sccm.reporting user and other desired users
  4. Open SQL Management Studio and grant sccm.reporting user rights (and whoever else) to the new ReportServer databases

Add the Reporting Services role in SCCM. At this point, I logged in as myself on the SCCM server

  1. Administration tab > Servers and Site System Roles > Add Site System Role
  2. [x] Reporting Services Point
  3. Verify all information is correct, then click on Verify button
  4. UN: sccm.reporting, enter password
  5. Next, Finish
  6. [OPTIONAL] You can verify that the role installs successfully by using CMTrace and open the SRSRP.LOG and/or SRSRPSetup.log file

Monitoring tab > Reports

  1. Wait a few minutes and SCCM will populate this area w/ about 423 items
  2. At this point you can log back into http://systemcenter/Reports provided you gave yourself permission from the steps above. When using Internet Explorer, choose Run As Administrator. or use a different browser. You should also see reports listed here as well.

From here on, you can view reports, create subscriptions, etc.

No comments:

Post a Comment