The following error may occur when opening the New Subscription Wizard in the My Subscriptions section of the Quest Knowledge Portal:
The account credentials used to login to the Quest Knowledge Portal are missing specific rights in the SQL Reporting Services.
1. Open the SQL Server Management Studio
2. Connect to the "Reporting Services" not the "Database Engine"
3. On the left hand side, expand Security | System Roles
4. Right click on "System Roles" and create a new role
5. Grant this new role only "View shared schedules"
6. Open the Report Manager website (http://servername/reports)
7. Click on "Site Settings" on the top right hand of the web page and then "Configure site-wide security" at the bottom of the new page
8. Click on "New Role Assignment"
9. Type the "domain\username" or the "domain\groupname" for the object who needs access to create subscriptions and select the new system role
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center