Citrix EdgeSight : Reporting Services Error

EdgeSight 5.3 has been implemented for XenApp 6 environment on Windows 2008 R2. While extracting XenApp summary it was throwing Reporting service error.

We looked at Reporting service on 2008 SQL server which was hosted on another windows server ,was working fine. Checked the link http://<localdb severver>/ReportServer and that also was fine. We reconfigure reporting services. We decided to enable remote errors using following steps

________________________________________
1.    Create a text file and copy the following script into the file.
Copy
Public Sub Main()
  Dim P As New [Property]()
  P.Name = "EnableRemoteErrors"
  P.Value = True
  Dim Properties(0) As [Property]
  Properties(0) = P
  Try
    rs.SetSystemProperties(Properties)
    Console.WriteLine("Remote errors enabled.")
  Catch SE As SoapException
    Console.WriteLine(SE.Detail.OuterXml)
  End Try
End Sub
2.    Save the file as EnableRemoteErrors.rss.
3.    Click Start, point to Run, type cmd, and click OK to open a command prompt window.
4.    Navigate to the directory that contains the .rss file you just created.
5.    Type the following command line, replacing servername with the actual name of your server:
Copy
rs -i EnableRemoteErrors.rss -s http://servername/ReportServer

With this I rerun the report and found following error . This gave me more elaborated error message .This help us to troubleshoot further.

We realize something wrong with permission . We started looking at SQL server and set following permission.

We rerun the report and we finally got the report