I have an asp.net 2.0 application using the report viewer control.
I am NOT using windows authentication. In my web.config file, I have a
userName and Password for an activeDirectory user that has accces to our
reporting services server (actually, I am using my own username and password
for testing right now to avoid one less "item" in this equation). I create
a Credentials object and assign it to the report viewer like this...
IReportServerCredentials irsc = new
CustomReportCredentials(UserFromConfigFile, PasswordFromConfigFile,
ReportDomainFromConfigFile);
ReportViewer.ServerReport.ReportServerCredentials = irsc;
And these are my other properties for the report viewer...
ReportViewer.ProcessingMode = ProcessingMode.Remote;
ReportViewer.ShowCredentialPrompts = true;
ReportViewer.ShowExportControls = true;
ReportViewer.ServerReport.ReportPath =
string.Concat(ReportPathFromConfigFile, "ReportName");
ReportViewer.ServerReport.ReportServerUrl = new
Uri(ReportServerUrlFromConfigFile);
I have a simple report that will run for me EVERYTIME when I go directly to
the reporting services server to view the report.
IF I have viewed the report on the RS server, then in my web application it
will display... If I wait 10 minutes or so, I get the following error when I
try to view the report via my web application.
ERROR:
An error has occurred during report processing.
Cannot create a connection to data source
'TransactionServer.CFApp_Management'.
Login failed for user '(null)'. Reason: Not associated with a trusted SQL
Server connection.
IF I go back and view the report on the RS server again, the report on my
web application is displayed again without an error once I refresh the web
page in my web application.
It seems like there is some caching or something going on, but I have no
idea and am at a loss!
Please help, thanks in advance!
Brian
AutoTrackerPlus - 10 Jul 2008 16:41 GMT
In case anyone else has this issue, I figured it out...
I was not setting the Domain when I was creating my CustomReportCredential
object, and when I did set it, my issue went away.
IReportServerCredentials irsc = new
CustomReportCredentials(CustomReportUser, CustomReportPassword,
CustomReportDomain);
>I have an asp.net 2.0 application using the report viewer control.
>
[quoted text clipped - 43 lines]
>
> Brian