Logon Failed in Crystal Reports Viewer
A while back, I created a small Web app with a menu that lets you select a report, and then a web form that takes in the parameters for the report, and then a web form for each report. I'm successfully using the Session object to transmit the parameters between the parameter page and the actual report page (web form), and then setting the parameters in the report document.
The reports are all 'external' reports created in CR10.
Each report is a single main report pointing to a view in a SQL Server database using an ADO connection to the database.
Each web page (created in VS 2003 using CR.Net 10) has a viewer control and a report document control that points to a folder where the .rpt files are stored.
The Viewer points to the report document.
CrystalReportViewer1.ReportSource = rptDailyTrans
(set the parameters here)
CrystalReportViewer1.DataBind()
This is the only coding I've had to do. I haven't had to code in any logon information at all because it seems to be picking it up from the report itself in the first application I created.
But, now I've created a new web app that should function exactly the same way. I believe the rights and permissions are the same in IIS for both apps. Certainly, all the reports connect the same way to SQL - they actually use the same SQL Server login to connect. Aspnet has all the permissions it needs to the Inetpub folder.
I can get one of the new reports to connect and display in the original web project. But I get a logon failure when I try to do the same in the new project. I've even tried coding in the connection information, with no success. I get prompted to reenter the logon information, but the report never displays.
So, what did I screw up? How come my reports won't display? Why won't they connect to SQL Server?
HELP! These reports were due last Monday! Any suggestions? I can't figure out what could be different!
Thanks!
Karen Grube
