Adding Custom Credentials to a Remote Report Server

You can provide all VSA users with a credential that lets them run SSRS reports. This eliminates the need to maintain access rights for each VSA user requiring access to the SSRS. This applies in particular to VSA users in a workgroup instead of a domain, who don't have a centralized method of authentication such as Active Directory to manage access rights to the SSRS.

This procedure creates a credential for a dedicated user called KaseyaReport in the system hosting the SSRS. Report Manager is used to give the KaseyaReport user access to running reports in the SSRS. Finally, the credential is registered in the System > Configure of the VSA. From that point forward the VSA uses that credential to access the SSRS every time a VSA user runs a report.

1. On the system hosting the SSRS, add a KaseyaReport user.
   • Give the user a strong password.
   • Uncheck the User must change password at next logon field.
   • Check the User cannot change password and Password never expires fields.

   

2. Apply appropriate permissions to the new user for your environment.
3. Open Reporting Service Configuration Manager.
4. Connect to the Report Server instance.
5. Navigate to Web Portal URL.
6. Click the URLs link. You may be prompted for username and password. Just use your domain account.

   

7. You should see the following Home screen. Click the gear icon > Site Settings option.

   

8. Click the Security menu option.
9. Click the Add group or user button.

   

10. Enter the username that was created in step 1 in the Group or user name field, for example, KaseyaReport.
11. Select System User checkbox
12. Click Add.
13. In the VSA, display the System > Server Management > Configure page. Click on the Change URL button to open the Report Configuration dialog.

    

14. Click on the Edit button at the top of the page.

    

15. Enter the credential you defined in step 1 and make sure the Specify Account checkbox is checked. This means SSRS will use the credential you entered. If the user, for example KaseyaReport, is not a domain user you can leave the Domain field blank.

    

16. Click Save and then click on the Test button to test the changes.

    

17. If everything is correct you should see the following screen.
18. If you mistyped the credentials you should see the following error message. Ensure that the credentials are correct and retest.