How to install and configure SCCM 2012 SP1 SQL Reporting Service role – Simplified

 Though it sound easy and pretty straight forward to those who have successfully installed SRS role and using it since sometime, but for those who haven’t tried it yet or one who tried but ran into some or other issues might find below information helpful to install SQL Reporting Service role successfully in their SCCM 2012 SP1 (goes well with earlier versions as well)

 Prerequisites

 1.SQL Reporting Service feature is selected & installed successfully during SQL Installation. Please check online documentation for updates on supported SQL versions, which anyways you will take good care during / for SCCM install

 2.SQL Reporting Services configuration – This is an important prerequisite and ensure you have configured reporting services with in SQL server and it functions well (leaving SCCM side for now). By default this feature in SQL will be in un configured state and you need to configure it for reporting services to work and also for SRS role installation in SCCM

 Tip:  Easiest way to find out if Reporting Services Features is successfully configured or not, is through “Add Site System Roles wizard” during “reporting service point” in SCCM Console. You will find that “reporting service server instance” isn’t rendered and will be blank, which means install will not be progressed further. This is the clear indication that reporting services in SQL is neither installed or nor configured successfully

 a)      Start > Programs > SQL 2008 R2 (which ever version you have)

 b)        Configuration Tools > Reporting Services Configuration Manager. Most of the settings are there and auto filled for you, you just need to apply to confirm the same configuration

 c)      Service Account Window

 Chose the account of your choice to run “Reporting Services” service, either domain or local system account etc

 d)      Web Service URL Window

 This selection presents you values which you need to confirm by clicking apply. Settings including TCP Port at which site listens on, URL of reporting server (not the page that contain reports), IP Address etc.

 e)      Report Server Database Creation Window

 Database to store SQL Reporting Services isn’t created by default and this wizard allows you to do so, below screen shots will be of help and confirm the data base is created and you could test connect it successfully using the wizard

 f)       Report Manager URL

 You may accept the defaults of “Reports” as virtual directory that wizard offers and look for successful indication of URL reserved

 g)      E-mail Settings Window

 This optional configuration helps you to configure so reports can be sent to all users over email at given schedules.  Before configuring , you will need to work with you communications team to allow SCCM server to talk to SMTP and also get SMTP Server name etc. details

 h)      Execution Account Window

 This wizard helps you to feed in any account that you would like to designate to access SQL DB when reports are read/mailed etc. I recommend to configure an account with READ permission to DB, with this users who access reports doesn’t need to have rights to SQL DB directly

 Verify Successful Install & Configuration

 You can refer to \\SCCMServer\c$\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\LogFiles for successful configuration of reporting services feature

 •Open web service URL that is configured during configuration and see it opens up well

 •Open report Manger URL that is configured during configuration and see it opens up well. In case of any issues with these URL opening, please refer to below related logs which will guide you with exact error

 

 Related logs

 file://sccmserver/c$/Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\LogFiles - Most of the times I find right clue here to resolve any issues that may arise in SRS

Reporting Service Point Install & Configuration

 Ensure all of above prerequisites are met before “Reporting Point” role install in SCCM is initialized

 • Follow through instructions of wizard in SCCM Console 

 • Verify the SQL Server and SCCM DB name presented to you. Look for “Successfully verified”

 • Chose a folder that will be created on SQL Reporting Service web site, SCCM role install wizard  copies all reports to this folder. You will not see all SCCM  
   category folders (like asset intelligence or Client Health etc) at once as they will take some time to create, one by one

 Verify Successful Install & Configuration

 Found under \\SCCMServer\SMS_<SiteCode>\Logs

 •Srsrpsetup indicates below snippet, using which you confirm success (or otherwise) status of reporting services point role install

Installing C:\Program Files\Microsoft Configuration Manager\bin\x64\srsrp.msi SRSRPINSTALLDIR="C:\Program Files\SMS_SRSRP" SRSRPLANGPACKFLAGS=0
srsrp.msi exited with return code: 0
Installation was successful.

  •srsrpMSI.log  indicates below snippet towards end of installation which confirms it success

 MSI (s) (BC:48) [14:56:51:167]: Windows Installer reconfigured the product. Product Name: ConfigMgr Reporting Services Point. Product Version: 5.00.7804.1000. Product Language: 1033. Manufacturer: Microsoft Corporation. Reconfiguration success or error status: 0.

 Related logs found under \\SCCMServer\SMS_<SiteCode>\Logs

srsrpMSI.log
srsrpsetup.log