Use Configuration Manager to configure the report service

1. log on to the SQL Server server and open the Reporting Services Configuration Manager.

2. Click the service account and set the Service Running Account to "local system"

650) This. width = 650; "Height =" 295 "Title =" clip_image002 "style =" margin: 0px; "alt =" clip_image002 "src =" http://img1.51cto.com/attachment/201409/8/8995534_1410180266ILbb.jpg "/>

3. Click the Web Service URL to confirm the setting.

650) This. width = 650; "Height =" 309 "Title =" clip_image004 "style =" margin: 0px; "alt =" clip_image004 "src =" http://img1.51cto.com/attachment/201409/8/8995534_1410180267BzZ7.jpg "/>

4. Click database to confirm that the database has been created.

650) This. width = 650; "Height =" 317 "Title =" clip_image006 "style =" margin: 0px; "alt =" clip_image006 "src =" http://img1.51cto.com/attachment/201409/8/8995534_1410180267cfNV.jpg "/>

5. Click the report manager URL to confirm that the URL has been created and can be accessed normally.

650) This. width = 650; "Height =" 325 "Title =" clip_image008 "style =" margin: 0px; "alt =" clip_image008 "src =" http://img1.51cto.com/attachment/201409/8/8995534_1410180267ykft.jpg "/>

6. log on to the Configuration Manager server and open the Configuration Manager Console.

7. Click Manage to expand site configuration. Click site, right-click Site Server, and select Add site system role.

8. Add "Reporting Services" to the Site System

650) This. width = 650; "Height =" 256 "Title =" clip_image010 "style =" margin: 0px; "alt =" clip_image010 "src =" http://img1.51cto.com/attachment/201409/8/8995534_14101802677SF6.jpg "/>

9. Specify the reporting services setting point to provide integration with SQL Server reporting services for Configuration Manager to create and manage reports.

650) This. width = 650; "Height =" 338 "Title =" clip_image012 "style =" margin: 0px; "alt =" clip_image012 "src =" http://img1.51cto.com/attachment/201409/8/8995534_1410180267VuDp.jpg "/>

10. Wait for the Wizard to complete adding the site system role

650) This. width = 650; "Height =" 213 "Title =" clip_image014 "style =" margin: 0px; "alt =" clip_image014 "src =" http://img1.51cto.com/attachment/201409/8/8995534_14101802688n9b.jpg "/>

11. Use cmtrace log analysis tools to monitor the installation status of reporting services

650) This. width = 650; "Height =" 334 "Title =" clip_image016 "style =" margin: 0px; "alt =" clip_image016 "src =" http://img1.51cto.com/attachment/201409/8/8995534_1410180268YhDJ.jpg "/>

12. Click "Monitor" to expand the report. Click "report" to view the currently generated report information.

650) This. width = 650; "Height =" 381 "Title =" clip_image018 "style =" margin: 0px; "alt =" clip_image018 "src =" http://img1.51cto.com/attachment/201409/8/8995534_1410180269s3Ai.jpg "/>

13. Open the report service URL again to view the generated report.

650) This. width = 650; "Height =" 391 "Title =" clip_image020 "style =" margin: 0px; "alt =" clip_image020 "src =" http://img1.51cto.com/attachment/201409/8/8995534_1410180269Q78l.jpg "/>

14. Right-click "client Status Summary" in report service and select "run ".

650) This. width = 650; "Height =" 378 "Title =" clip_image022 "style =" margin: 0px; "alt =" clip_image022 "src =" http://img1.51cto.com/attachment/201409/8/8995534_1410180270a4Mh.jpg "/>

15. Select a restricted set and Client Version, and click View Report.

650) This. width = 650; "Height =" 209 "Title =" clip_image024 "style =" margin: 0px; "alt =" clip_image024 "src =" http://img1.51cto.com/attachment/201409/8/8995534_14101802709Byv.jpg "/>

16. view the generated client Summary Report

650) This. width = 650; "Height =" 379 "Title =" clip_image026 "alt =" clip_image026 "src =" http://img1.51cto.com/attachment/201409/8/8995534_1410180270yWLT.jpg "/>

View different reports based on the actual environment

This article is from "Xu Ting's blog", please be sure to keep this source http://ericxuting.blog.51cto.com/8995534/1549943

Use Configuration Manager to configure the report service