How to Configure SQL Server 2016 Reporting Services for Configuration Manager Reporting Point Role Installation. In this guide, we make some configurations to SQL serveris 2016 Reporting Services Configuration Manager for future installation SCCM Reporting Point Role.
1. Log in to your system with SQL Server;
2. Į ALL Programs find and run Reporting Services Configuration Manager;
3. At Report Server Instance select your instance (in my case Configuration Manager server) ir spustelėkite Connect;
4. For Service Account leave default settings;
5. For Database spustelėkite Change Database;
6. Select the option Create a new report server database ir spustelėkite Kitas;
7. At Server Name įveskite <Your SQL Server name>\<Your instance name> ir spustelėkite Test Connection;
8. If the test succeeds click Gerai ir Kitas;
9. Įeikite the Database Name and choose Language, spustelėkite Kitas;
10. Palikite pagal numatytuosius nustatymus Credentials ir spustelėkite Kitas;
11. For Summary spustelėkite Kitas;
12. Database creation begins;
13. When complete click Baigti;
14. For Web Service URL enter the name of the Virtual Directory, enter TCP Port, and if you have SSL – config options for SSL. When complete click Taikyti;
15. Directory created and port reserved;
16. For į Web Portal URL enter the name of the Virtual Directory ir spustelėkite Taikyti;
17. Directory created and port reserved;
18. For Encryption Keys spustelėkite Backup;
19. Click the button with dots to specify the output path and filename. Enter a STRONG password and click Gerai;
20. For finishing all steps, we need to restart Reporting Services. Eiti į <Serverio pavadinimas>\<instance name> ir spustelėkite Stop;
21. After that click Pradėti;
22. We make all configurations for future SCCM Reporting Point Role installation and may close the console.
Don’t forget to make another backup of your encryption key (as an example to OneDrive).