In this guide, we make some configuration to SQL Server 2012 Reporting Services Configuration Manager for future installation SCCM Reporting Point Role.

  1. Login to your system with SQL Server;

2. In ALL Programs find and run SQL Server Reporting Services Configuration Manager;

3. At Report Server Instance select your instance (in my case SCCM) and click Connect;

4. For Service Account leave default settings;

5. For Report Server Database click Change Database;

6. Select option Create a new report server database and click Next;

7. At Server Name enter <Your SQL Server name>\<Your instance name> and click Test Connection;

8. If test succeed click OK;

9. Click Next;

10. Enter Database Name and choose Language, click Next;

11. Leave by default Service Credentials and click Next;

12. For Summary click Next;

13. Database creation begin;

14. When complete click Finish;

15. For Web Service URL enter name of Virtual Directory, enter TCP Port (I use 8080) and if you have SSL – config options for SSL. When complete click Apply;

16. Directory created and port reserved. Don’t forget create Windows Firewall rules for your ports;

17. For Report Manager URL enter name of Virtual Directory and click Apply;

18. Directory created and port reserved;

19. For Encryption Keys click Backup;

20. Click button with dots to specify output path and filename.

21. Enter STRONG password and click OK;

22. For finishing all steps, we need restart Reporting Services. Go to <Server name>\<instance name> and click Stop;

23. After that click Start;

We make all configurations for future SCCM RP Role installation and may close console. Copy certificate to your certificates storage, make some bakup.