Next Topic

Previous Topic

Book Contents

Remote SSRS 2008 Configuration

When SSRS 2008 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 your SQL Server 2008 box.
  2. Open Reporting Service Configuration Manager.

    Word 40% / HTML 40%

  3. Connect to the Report Server instance.

    Word 50% / HTML 100%

  4. Navigate to Report Manager URL. Click the link labeled URLs. You may be prompted for username and password. Just use your domain account.

    Word 50% / HTML 100%

  5. You should see the following screen. Click on Site Settings.

    Word 50% / HTML 100%

  6. Then click Security on the left hand side of the page.

    Word 50% / HTML 100%

  7. Then click New Role Assignment.

    Word 50% / HTML 100%

  8. Create a role call Everyone with System User. Click OK.

    Word 50% / HTML 100%

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

    Word 50% / HTML 100%