Advanced reporting
and data visualization components for .NET
LIVE CHAT Welcome, guest
Forums > Silverlight Viewer for Reporting Services 2005

 





Server error
Display Posts for:
Invert
Dragan Siskov 04/26/2010 07:48
Server error

Hi all,

I am trying out the trial version of the Report Viewer for SQL 2005 Reporting Server;

I have problems with the connection somehow;

I am using:
VS 2010 Premium
Silverlight 4
.NET Framework 3.5

I double checked the web.config sections to match the 'Getting Started' document that I got with the trial version;
This is the only difference :
<PerpetuumSoftServices>
<Service Type="2010Reports3_5.Web.ReportService, 2010Reports3_5.Web">
<MsReportingServer Url="http://localhost/reportserver/ReportExecution2005.asmx">
<Credentials Domain="myDomain" UserName="Windows UserName" Password="testing1!"/>
</MsReportingServer>
</Service>
</PerpetuumSoftServices>

Now, when I have anything done (added references, modified web.config, added your control), I run the project;


I can see the control, its progress bar loading, and after some seconds, I get:
Server error
An error occurred on the server. Please contact the system administrator.


This is the look of the control:
<rss:ReportViewer x:Name="rv" ServiceUrl="http://localhost:5555/ReportService.svc" ReportName="Testing/short_report" />

I have no problems to view the 'short_report' from
http://localhost/Reports/Pages/Report.aspx?ItemPath=%2fTesting%2fshort_report


Can you tell me what am I doing wrong?
Back to Top    Quote
Vlad Nekrasov 04/27/2010 05:06
Server error

Hello,

As it is seen from the error, you’ve got no privileges to view the report you request.
In your browser, open the folder of the virtual catalogue of your SSRS service and click “Property” tab. Edit security parameters. Add your user (Domain="myDomain" UserName="Windows UserName" Password="testing1!") into the group of users allowed to read the report.

Best regards,
Vlad Nekrasov
Perpetuum Software Team
Back to Top    Quote
Dragan Siskov 04/27/2010 08:57
Server error

Hi,

Thanks for the answer;
I made the changes you proposed:
1. Added my 'Windows Username' (through ReportManager, though it didn't ask me to specify any credentials) to the folder containing the report, and gave it all existing roles (Browser, Content Manager, My Reports, Publisher, Report Builder)
2. Started the application from vs2010, and the same error remained.

Can you tell me if I made a mistake in the permission-giving or somewhere else?
Back to Top    Quote
Vlad Nekrasov 04/28/2010 00:38
Server error

Hello,

Check if the service is available via http. Type the following in your browser address bar:
http://localhost/reportserver/ReportExecution2005.asmx
Check SSRS documentation in order to set SSRS accounts correctly
It is really hard for us to find out the reason of the error, but there is no doubt that it is connected either with SSRS service security settings, or IIS server security settings

Best regards,
Vlad Nekrasov
Perpetuum Software Team
Back to Top    Quote
Dragan Siskov 04/28/2010 03:03
Server error

Hi Vlad,

Thanks for replying me
I do have access to http://localhost/reportserver/ReportExecution2005.asmx

I am checking the security of the IIS and SSRS, which seems fine...

I want to point out the following:

Whether I run the page with valid URL for the reporting server, or invalid one, I get the same error message on your control;
i.e. valid one:

<MsReportingServer Url="http://localhost/reportserver/ReportExecution2005.asmx">
<Credentials Domain="domain" UserName="user" Password="testing1!" />
</MsReportingServer>

invalid one:
<MsReportingServer Url="http://localhos2t/report3server/ReportExecution2005.asmx">
<Credentials Domain="domain" UserName="user" Password="testing1!" />
</MsReportingServer>

Please note that I am running a vs2010 project locally
Back to Top    Quote
Vlad Nekrasov 04/28/2010 06:05
Server error

Hello,

Study our example about Credential settings
http://www.perpetuumsoft.com/sf/en/fls/slviewerforrs/SilverlightViewerForReportingServicesGettingStartedSample_sl4.zip
If you still have this problem, you can send us your application. We will test it using our SSRS and bring out the problem.

Best regards,
Vlad Nekrasov
Perpetuum Software Team
Back to Top    Quote
Dragan Siskov 04/28/2010 09:17
Server error

Hi again,

I built the project you sent me, installed the Adventure Works Sample Reports, attached the 'Product Line Sales' report to my RemoteServer;
The report works properly in ReportManager.

I just modified this line in the project:
<Credentials Domain="" UserName="<username>" Password="<password>"/>

-> Started the project
-> The control begins loading, then rendering, and then the error appears

Note: I now spotted that the parameters for the requested reports are loaded (the configuration icon is enabled -> on click, drop-down menu is shown with correct parameter names and values)

This leads me to the fact that the control was successfully connected to the ReportingServer, got the info about the report, but somehow didn't have permission to actually run the report;

_____________________________________________
This are my settings for the IIS Virtual Directories (both for Reports and ReportServer):

Anonymous authentication - disabled
asp.net impersonation - enabled
forms authentication - disabled
windows authentication - enabled

Application pool - Classic .Net AppPool (Identity - LocalSystem (changed it from NetworkService, because then I could not see even the parameters of the report) )

_________________________________________________
In ReportingServicesConfigurationManager:

Web ServiceIdentity - NT AUTHORITY\SYSTEM
Windows ServiceIdentity -> Service Account - <Domain>\<username>


_________________________________________________
In ReportManager:

I added 'New Role Assignment' with <username> and given it all roles to:
Home\AdventureWorks Sample Reports folder (which contains only 'Product Line Sales' report)


I would really appreciate any heads up on this security matter...
Back to Top    Quote
Dragan Siskov 04/29/2010 02:50
Server error

Any idea?
Back to Top    Quote
Vlad Nekrasov 04/29/2010 04:45
Server error

Hello,

I’ve already offered you to send us your application and we will try to fix it. Our e-mail is [email protected].

Turn on logging if this variant is inappropriate for you.
You should add to the project "Server" a folder with name "Log",
And You should set property "DebugMode" for object "reportViewer" in the method "Page_Load" of "MainPage.Xaml" :

reportViewer.DebugMode = DebugModeEnum.Full;

Then the error messages will appear in your folder Log automatically.

In this case you will receive more detailed error message. Probably, that’ll help us solving your problem.

Best regards,
Vlad Nekrasov
Perpetuum Software Team
Back to Top    Quote
Dragan Siskov 04/29/2010 05:18
Server error

Hi

Vlad, I haven't begun working on my application yet, since I cannot even test the control properly; In other words, the only project I work on is the one you sent me!

The info about logging is definitely useful, however I can't access a property with name DebugMode (nor find an enum DebugModeEnum); I searched your documentation, and it isn't in there as well...

Please note (I thought it isn't important) that I had to remove and re-add the 'PerpetuumSoft.Reporting.Silverlight.MsReporting.Client' reference from the Silverlight project, as the project didn't build with the bundled one
Back to Top    Quote
Dragan Siskov 04/29/2010 08:57
Server error

Hi,

I fixed it by giving all roles to the report, in reportmanager...
Back to Top    Quote
Vlad Nekrasov 04/30/2010 00:34
Server error

Hello,

We are glad that your problems was resolved. If you will have any problems, please contact us.

Best regards,
Vlad Nekrasov
Perpetuum Software Team
Back to Top    Quote
Dragan Siskov 04/30/2010 02:44
Server error

Hi Vlad,

I would just like to point out what caused the problem:

It was not in the ReportServer permissions, nor IIS (pools, authorization), but within the PerpetuumSoft.XamlExtension.msi installation;

Even though I had it installed, during the time debugging, I checked the rsreportserver.config file and it didn't contain the <Extension Name="XAML" ... part in it;

Then, I repaired the installation, the extension was there and the control began working properly

Maybe this can help if someone has the similar problem...

Thanks
Back to Top    Quote
Vlad Nekrasov 04/30/2010 06:47
Server error

Hello,

Thank you for the information, everything is clear.

Best regards,
Vlad Nekrasov
Perpetuum Software Team
Back to Top    Quote