Configuration Manager SQL Server 2012 Reporting Services. In this guide, we make some configurations to SQL Server 2012 Reporting Services Configuration Manager for future installation SCCM Reporting Point Role.
1. Log in to your system with SQL Server;
2. In All Programs find and run SQL Server Reporting Services Configuration Manager;
3. на Report Server Instance select your instance (in my case SCCM) і натисніть Connect;
4. For Service Account leave default settings;
5. For Report Server Database click Change Database;
6. Select the option Create a new report server database і натисніть Далі;
7. на Server Name введіть <Your SQL Server name>\<Your instance name> і натисніть Test Connection;
8. If the test succeeds click добре;
9. Натисніть Далі;
10. Enter the Database Name and choose Language, click Далі;
11. Leave by default Service Credentials і натисніть Далі;
12. For Резюме click Далі;
13. Database creation begins;
14. When complete click Finish;
15. For Web Service URL enter the name of Virtual Directory, введіть 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 to create Windows Firewall rules for your ports;
17. For the Report Manager URL enter the name of the Virtual Directory і натисніть Apply;
18. Directory created and port reserved;
19. For Encryption Keys click Backup;
20. Click the button with dots to specify the output path and filename.
21. Enter a STRONG password and click добре;
22. For finishing all steps, we need to restart Reporting Services. Go to <Server name>\<instance name> і натисніть Stop;
23. After that click Start;
We make all configurations for future SCCM RP Role installation and may close the console. Copy the certificate to your certificates storage, and make some backup.
