Installing SQL Server Reporting Services is just the first step in building the foundation for a solid Reporting Services instance. The second step in the process is. Global Compliance and Reporting GCR is at a tipping point. Many companies distribute responsibility for GCR processes throughout their organization creating a. Learn to easily and correctly configure Kerberos delegation for your Microsoft SQL Server Reporting Services SSRS environment. IC541106.gif' alt='Reporting Services Client Tools' title='Reporting Services Client Tools' />How to Successfully install Reporting Services Point Role in SCCM 2. SP1 Tech. Net Articles United States EnglishHow to install and configure SCCM 2. 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 havent tried it yet or one who. SQL Reporting Service role successfully in their SCCM 2. 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. 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. 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 isnt 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 2. R2 which ever version you have b        Configuration Tools Reporting Services Configuration Manager. Reporting Services Client Tools' title='Reporting Services Client Tools' />One of the main attractions to integrating SharePoint with SQL Server Reporting Services, is to allow users to create, modify publish reports from within. Most of the settings are there and auto filled for you, you just need to apply to confirm the same. Service Account Window Chose the account of your choice to run Reporting Services service, either domain or local system account etc. 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. IP Address etc.  e. Report Server Database Creation Window Database to store SQL Reporting Services isnt 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. Microsoft Office Superscript Shortcut'>Microsoft Office Superscript Shortcut. Report Manager URL You may accept the defaults of Reports as virtual directory that wizard offers and look for successful indication of URL reserved. Feature-Selection.jpg' alt='Reporting Services Client Tools' title='Reporting Services Client Tools' />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. Kirby Select on this page. SCCM server to talk to SMTP and also get SMTP Server name etc. 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 readmailed etc. I recommend to configure an account with READ permission. DB, with this users who access reports doesnt need to have rights to SQL DB directly. Verify Successful Install Configuration. You can refer to SCCMServercProgram FilesMicrosoft SQL ServerMSRS1. Server-Configuration.jpg' alt='Reporting Services Client Tools' title='Reporting Services Client Tools' />MSSQLSERVERReporting ServicesLog. Files 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. Under the Critical client incident management instruction technical update 2014 the incident reporting instruction all services delivered directly by the Department. Related logs file sccmservercProgram FilesMicrosoft SQL ServerMSRS1. MSSQLSERVERReporting ServicesLog. Files Most of the times I find right clue here. SRSReporting Service Point Install Configuration. Bichunmoo 2000'>Bichunmoo 2000. 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. Reporting Services Client Tools' title='Reporting Services Client Tools' />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 SCCMServerSMSlt Site. Code Logs Srsrpsetup indicates below snippet, using which you confirm success or otherwise status of reporting services point role install. Installing C Program FilesMicrosoft Configuration Managerbinx. SRSRPINSTALLDIRC Program FilesSMSSRSRP SRSRPLANGPACKFLAGS0. Installation was successful. MSI. log  indicates below snippet towards end of installation which confirms it success. MSI s BC 4. 8 1. Windows Installer reconfigured the product. Product Name Config. Mgr Reporting Services Point. Product Version 5. Product Language 1. Manufacturer Microsoft Corporation. Reconfiguration success or error status 0. Related logs found under SCCMServerSMSlt Site. Code Logssrsrp. MSI. MSI Worldwide. Our field projects span the globe. We have more than 1. Iraq, Jordan, Afghanistan, South Sudan, Pakistan, Colombia, Paraguay and Kenya.