Remote SSRS Configuration

When SSRS is remote from the Kaseya Server and attempting to run a VSA report displays the following connection error...

ERROR: The permissions granted to user '<domain>\<username>' are insufficient for performing this operation

... perform the following configuration.

Creating an "Everyone" System User in Report Manager

The following procedure sets "site wide" security settings for all users accessing SSRS.

  1. Login to the system hosting SQL Server.
  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 Everyone in the Group or user field.
  2. Then click OK.

Word 50% / HTML 50%

  1. You’re done! Your report should be running now.

Word 50% / HTML 50%