SQL Server Reporting service

In Configuration Manager , the reporting service point communicates with SSRS(SQL Server Reporting Service)to copy the SCCM reports to a specified folder. Reporting service role plays a major role in configuration Manager 2012 for pulling organised information about inventory, application deployment, patching and  software mettering data.  Configuration Manager provides report definitions for over 450 reports in over 50 report folders, which are copied to the root report folder in SQL Server Reporting Services during the reporting services point installation process. The reports are displayed in the Configuration Manager console and organized in subfolders based on the report category.
Before proceeding with the configuration,
1. Make sure SQL Server Reporting service installed
2. Make sure the connectivity of Reporting Services with site database.
SQL Server Reporting service installation
To verify the SQL server reporting service installation in  windows server 2008, click Start ->click All Programs-->click Microsoft SQL Server 2008 R2-->click Configuration Tools --> click Reporting Services Configuration Manager.
To verify the SQL server reporting service installation in  windows server 2012, Just serach for Reporting Services Configuration Manager in Search column.
If  Reporting Services Configuration Manager is not found run the SQL setup and proceed with installation of Reporting services Configuration Manager. Else, open the Reporting service configuration manager and start working with the connectivity verification.
Make sure the connectivity of Reporting Services with site database
Click, Reporting services Configuration Manager
Provide SQL server name and instance name to connect.

Once you connected, Make sure the Report server mode is Native and and reporting service is up and running , else start the reporting service.

Make sure the database Name and service account that connects the Database .

Specify the virtual Directory  and configure a URL to access the Report server . If you have created any SSL certificate for authentication, mention it in SSL certificate column , else proceed with default.
Configure a URL to acess report Manager , So that You can use this URL in future to add folders or to create custom SQL reports by accessing Report Manager .

Once the verification and configuration from SQL Server Reporting service done, proceed with the installation of Reporting Service point configuration Manager role.

Installation of Reporting Service Point
 
To manage report reporting site role must be installed. The reporting services point copies report folders and reports to SQL Server Reporting Services and it applies the security policy for the reports and folders, and sets the configuration settings in Reporting Services.The reporting services point is a site system role that must be configured on a server with Microsoft SQL Server Reporting Services installed and running .
Installation of Reporting Service Point
  1. Run SCCM site role installation Wizard
  2. Skip the Proxy tab, if you don’t have proxy environment
  3. Select the Reporting Services point role to install


Mention the site database server and database name, run the verification wizard and check for successful verification.
Specify the folder to create on the site system server reports that will contain the SCCM 2012 reports.
Select reporting server instance name, if the instance name is not available, then the SQL server reporting service is not running/installed.
Specify the user name that have read access to configuration manager database.

Click Next

After the successful installation wizard , verify the site server logs
Related logs found under \\SCCMServer\CCM\ Logs
srsrpMSI.log
srsrpsetup.log  

srsrpsetup.log  
Check for the below successful log entry
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
Check for below log entry in srsrpMSI.log
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.
After the successful installation , verify the reporting tab in configuration Manager console. The report manager and report server url can be seen .click on the Report Manager link and make sure the folders you have created is found and it has all the inbuilt SCCM reports found in consle.

Click the folder and view the report .
Thanks Guys!! I will continue with creation of custom report in next post.


Translate

Total Pageviews

Blog Archive

Followers

Linkedin

Popular Posts