Next Topic

Previous Topic

Book Contents

Remote SSRS 2005 Configuration

When SSRS 2005 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. Logon to the system hosting SQL Server 2005.
  2. Open IIS Manager
  3. Navigate to the Report virtual directory.
  4. Right-click Home.aspx and select the Browse option.

    Word 50% / HTML 100%

  5. Click the Site Settings link.

    Word 50% / HTML 100%

  6. Then click Configure site-wide security.

    Word 50% / HTML 100%

  7. Then click New Role Assignment.

    Word 50% / HTML 100%

  8. Create a user called Everyone and assign the System User role to this new user. Click OK.

    Create a new user called 'Everyone' and assign the System User role Word 50% / HTML 100%

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

    Word 50% / HTML 100%