Home » ssrs

Tag: ssrs

Move the Citrix Edgesight SSRS report path

We recently had to move the Citrix Edgesight SSRS report server for a client for their Citrix Edgesight services.

Worth noting the following caveats when moving the SSRS report server location from edgesight

  1. All Custom reports are deleted
  2. All existing report subscriptions are deleted
  3. The standard edgesight reports will be uploaded to the new server under http://%server%/%reports%/Citrix/Edgesight/GUID/*
  4. Only the default edgesight schedules are created

NOTE: This does not affect any alerts / alert rules you have configured – these are left intact. (which is great!)

Citrix edgesight SSRS move alert

Also permissions for the service account need to be set as follows

  • Administrator role under Site-wide Security to allow uploading of schedules.
  • Administrator role in the root folder of the SSRS site to allow uploading of reports.
  • “Log on Locally” user right on the SSRS server.

Note the report services path can changed from within the edgesight console

  1. login as someone with edgesight admin rights (manage server settings)
  2. Configure Tab
  3. Reporting Services
  4. Report server

Citrix edgesight SSRS Configuration page

Reference: How to move the Citrix Edgesight SSRS report path

 

Edgesight SSRS Permissions Configuration

Situation: when creating the new Edgesight SSRS solution the following changes had to be made to the SSRS server to allow the Edgesight to create folder, and upoad all its Reports etc

Solution:

Log into SSRS as Administrator
Click on site settings
choose security
add the necessary user (edgesiht admin account) as a system administrator…
Test link
Got to SSRS page
http://SERVER/Reports/Pages/Settings.aspx?SelectedSubTabId=SecurityLinkID
Log into SSRS as Administrator
Click on folder settings
choose security
add the necessary user as a Browser, Content Manager, My Reports, Publisher, Report Builder

Edgesight 5.4 report subscription error

Situation: When creating a new subscription report in edgesight you may get

Error Message:

edgesight_ssrs_reports_subscriptionerror

An error occurred creating the   subscription: An attempt has been made to use a delivery extension that is   not registered for this report server. —> Microsoft.ReportingServices.Diagnostics.Utilities.DeliveryExtensionNotFoundException:   An attempt has been made to use a delivery extension that is not registered   for this report server.

Solution:

Open the SQL Server Reporting services configuration manager for the edgesight database instance and edit the configure the ‘Email settings’ section.

In our instance the below settings below were blank