How to Configure SQL Server 2016 Reporting Services for Configuration Manager Reporting Point Role Installation. In this guide, we make some configurations to SQL服务器 2016 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 Reporting Services Configuration Manager;
3. At Report Server Instance select your instance (in my case Configuration Manager server) 然后单击 连接;
4. For Service Account leave default settings;
5. For Database 点击 Change Database;
6. Select the option Create a new report server database 然后单击 下一个;
7. At Server Name enter <Your SQL Server name>\<Your instance name> 然后单击 Test Connection;
8. If the test succeeds click 好的 和 下一个;
9. 进入 the Database Name and choose Language, 点击 下一个;
10. Leave by default Credentials 然后单击 下一个;
11. For 概括 点击 下一个;
12. Database creation begins;
13. When complete click 结束;
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 申请;
15. Directory created and port reserved;
16. For the Web Portal URL enter the name of the Virtual Directory 然后单击 申请;
17. Directory created and port reserved;
18. For Encryption Keys 点击 Backup;
19. Click the button with dots to specify the output path and filename. Enter a STRONG password and click 好的;
20. For finishing all steps, we need to restart Reporting Services. 前往 <Server name>\<instance name> 然后单击 停止;
21. After that click 开始;
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).
