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.

Credentials are specified in three locations:

  • User Accounts in the system hosting the SSRS.
  • SSRS Report Manager.
  • VSA > System> Configure > Change URL... > User Name

Procedure

  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.

Word 50% / HTML 50%

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

Word 50% / HTML 50%

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

Word 50% / HTML 50%

  1. Click the Security menu option.
  2. Click the Add group or user button.

Word 50% / HTML 50%

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

Word 50% / HTML 50%

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

Word 50% / HTML 50%

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

Word 50% / HTML 50%

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

Word 50% / HTML 50%

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

Word 50% / HTML 50%