472,353 Members | 2,232 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,353 software developers and data experts.

logon failed on bundled crystal report with ASP.NET

I come across the error
"CrystalDecisions.CrystalReports.Engine.LogOnExcep tion: Logon failed."
After I move my asp.net code from the development platform (XP
professional) to the production web server (windows 2003 server) by
generating the msi file from the setup and deployment project and
adding the merge modules. The msi file is installed to the windows 2003
server. The installation unzips all the files to the windows 2003
server. After moving to the new web server, I come across the logon
exception problem. Both my development sever and production server
access the same remote SQL server. Both severs do not have crystal
report installed because all the necessary files are contained in the
..dll that was installed by the .msi generated from the setup and
deployment project.
The logon is not due to the problem of the code because I have already
added the login information for every table as follows, and it works
for my development server.

public class maincharge : System.Web.UI.Page
{
protected CrystalDecisions.Web.CrystalReportViewer
CrystalReportViewer1;
mainchargeCR crReportDocument = new mainchargeCR();
mainchargemonCR crReportDocument2 = new mainchargemonCR();
TableLogOnInfo crTableLogOnInfo = new TableLogOnInfo();
ConnectionInfo crConnectionInfo = new ConnectionInfo();
CrystalDecisions.CrystalReports.Engine.Database crDatabase;
CrystalDecisions.CrystalReports.Engine.Tables crTables;
CrystalDecisions.CrystalReports.Engine.Database crDatabase2;
CrystalDecisions.CrystalReports.Engine.Tables crTables2;
......
private void Page_Load(object sender, System.EventArgs e)
{
string connectionString =
ConfigurationSettings.AppSettings["connString"];
crConnectionInfo.ServerName =
ConfigurationSettings.AppSettings["server"];
crConnectionInfo.DatabaseName =
ConfigurationSettings.AppSettings["database"];
crConnectionInfo.UserID =
ConfigurationSettings.AppSettings["userid"];
crConnectionInfo.Password =
ConfigurationSettings.AppSettings["password"];

crDatabase = crReportDocument.Database;
crTables = crDatabase.Tables;

foreach(CrystalDecisions.CrystalReports.Engine.Tab le crTable in
crTables)
{
crTableLogOnInfo = crTable.LogOnInfo;
crTableLogOnInfo.ConnectionInfo = crConnectionInfo;
crTable.ApplyLogOnInfo(crTableLogOnInfo);
}
if (!Page.IsPostBack)
{
}
}
}

Anyone knows if there is and "logon failed" problem with Windows 2003
server accessing a remote database from crystal report?

Thanks a lot for your help.

Feb 20 '06 #1
0 1549

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: Ambika Srinivasan | last post by:
Hi, I am getting the following error running a crystal report with VB.NET Exception Details: ...
1
by: Bob Skutnick | last post by:
Help.... I've created an ADO.NET dataset in Visual Studio (a web project). I build the project and then try to create a Crystal Report using the...
0
by: sztonix | last post by:
Hi all, I encountered a crystal report deployment problem. I make reports with Crystal Report for Visual Studio .NET 2003. It works fine in...
4
by: Rey | last post by:
Howdy all. Using VSNet 2003 on an XP Pro SP2 boox. Trying to use Crystal Reports to access an mdb file with access security/workspace. Simple...
2
by: Karun Karunakaran | last post by:
Hi, I am using the Crystal Enterprise .NET assemblies to generate and display a crystal report in a webform. This report connects to an SQL...
3
by: Milan Todorovic | last post by:
Hello, I need help. I have experience in ASP.NET programming, but this is my first dealing with Crystal Reports. I'm trying to make the most...
9
by: mollyf | last post by:
I have tried various suggestions that I have found searching the newsgroups and still haven't been able to figure why I keep getting the logon...
19
by: Michael O'Donnell | last post by:
Hi All Am having major problem with crystal reports...Have designed my report no problem, its when I try to run and display ther report that I...
3
by: Hugh O | last post by:
Hi, I have been trying to load a Crystal Report newly created via VS.Net 2003. I am using a simply ASP form with only the Crystal Report Viewer. ...
1
by: Kemmylinns12 | last post by:
Blockchain technology has emerged as a transformative force in the business world, offering unprecedented opportunities for innovation and...
0
jalbright99669
by: jalbright99669 | last post by:
Am having a bit of a time with URL Rewrite. I need to incorporate http to https redirect with a reverse proxy. I have the URL Rewrite rules made...
0
by: Matthew3360 | last post by:
Hi there. I have been struggling to find out how to use a variable as my location in my header redirect function. Here is my code. ...
0
by: Arjunsri | last post by:
I have a Redshift database that I need to use as an import data source. I have configured the DSN connection using the server, port, database, and...
0
by: Matthew3360 | last post by:
Hi, I have been trying to connect to a local host using php curl. But I am finding it hard to do this. I am doing the curl get request from my web...
0
Oralloy
by: Oralloy | last post by:
Hello Folks, I am trying to hook up a CPU which I designed using SystemC to I/O pins on an FPGA. My problem (spelled failure) is with the...
0
by: Carina712 | last post by:
Setting background colors for Excel documents can help to improve the visual appeal of the document and make it easier to read and understand....
0
BLUEPANDA
by: BLUEPANDA | last post by:
At BluePanda Dev, we're passionate about building high-quality software and sharing our knowledge with the community. That's why we've created a SaaS...
0
by: Rahul1995seven | last post by:
Introduction: In the realm of programming languages, Python has emerged as a powerhouse. With its simplicity, versatility, and robustness, Python...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.