Configuration Manager SQL Server 2012 Rapportageservices. 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. Bij Report Server Instance select your instance (in my case SCCM) en klik Connect;
4. Voor Service Account leave default settings;
5. Voor Report Server Database klik Change Database;
6. Select the option Create a new report server database en klik Volgende;
7. Bij Server Name binnenkomen <Your SQL Server name>\<Your instance name> en klik Test Connection;
8. If the test succeeds click OK;
9. Klik Volgende;
10. Enter the Database Name and choose Language, klik Volgende;
11. Leave by default Service Credentials en klik Volgende;
12. Voor Samenvatting klik Volgende;
13. Database creation begins;
14. When complete click Finish;
15. Voor Web Service URL enter the name of Virtual Directory, binnenkomen TCP Port (I use 8080), and if you have SSL – config options for SSL. When complete click Toepassen;
16. Directory created and port reserved. Don’t forget to create Windows Firewall rules for your ports;
17. Voor de Report Manager URL enter the name of the Virtual Directory en klik Toepassen;
18. Directory created and port reserved;
19. Voor Encryption Keys klik Backup;
20. Click the button with dots to specify the output path and filename.
21. Enter a STRONG password and click OK;
22. For finishing all steps, we need to restart Reporting Services. Gaan naar <Server name>\<instance name> en klik Stop;
23. After that click Begin;
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.
