Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
DB Engine
SQL ServerMSDESQL Server CE
Services
Analysis (Data Mining)Analysis (OLAP)DTSIntegration ServicesNotification ServicesReporting Services
Programming
CLRConnectivitySQLXML
Other Technologies
ClusteringEnglish QueryFull-Text SearchReplicationService Broker
General
Data WarehousingPerformanceSecuritySetupSQL Server ToolsOther SQL Server Topics
DirectoryUser Groups
Related Topics
MS AccessOther DB ProductsMS Server Products.NET DevelopmentVB DevelopmentJava DevelopmentMore Topics ...

SQL Server Forum / Services / Reporting Services / July 2008

Tip: Looking for answers? Try searching our database.

Report Viewer -ONLY works once in a while

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
AutoTrackerPlus - 09 Jul 2008 23:13 GMT
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
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.