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. On the system hosting the SSRS, open a browser and type in the URL for Report Manager, for example, http://localhost/Reports, using the Administrator account.

   

4. Click Site Settings at the top right hand corner.
5. Click Security in the right hand sidebar.
6. Click New Role Assignment along the menu bar.

   

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

    

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

    

12. 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.

    

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

    

14. If everything is correct you should see the following screen.

    

15. If you mistyped the credentials you should see the following error message. Ensure that the credentials are correct and retest.