.NETGURU
  Search:  
NamespacesDiscussions.NET v1.1Dot Net Guru's BlogIT Certification
CrystalReports: Logon Failed
Messages   Related Types
This message was discovered on ASPFriends.com 'ngfx-crystal' list.
Responses highlighted in red are from those people who are likely to be able to contribute good, authoratitive information to this discussion. They include Microsoft employees, MVP's and others who IMHO contribute well to these kinds of discussions.

Quale, Michael
We are creating our first Crystal Reports in VS.NET today! Yee Haa!
Anyway, we have had no problems connecting to the sample database and
generating the sample rpt's.
They work great.
The problem is when we try to create our own rpt's within our project and
try to connect to a non-local database we get an error which states:
"CrystalDecisions.CrystalReports.Engine.LogOnException: Logon Failed"

Any help would be greatly appreciated.

Thanks,

Mike Q.
Reply to this message...
 
    
Wolfgang Baeck
Same here and I haven't found a resolution yet. My interim solution is to
install the old crystal report page server (no licensing issue there!!), and
put the .rpt files into a separate directory from where I request them.

Advantage: Simple word and excel export along with printing due to client
side viewer (java or activex)

If you find a solution, please pass it on.

Wolfgang

-----Original Message-----
From: Quale, Michael [mailto:Click here to reveal e-mail address]
Sent: Wednesday, July 17, 2002 1:45 PM
To: ngfx-crystal
Subject: [ngfx-crystal] CrystalReports: Logon Failed

We are creating our first Crystal Reports in VS.NET today! Yee Haa!
Anyway, we have had no problems connecting to the sample database and
generating the sample rpt's.
They work great.
The problem is when we try to create our own rpt's within our project and
try to connect to a non-local database we get an error which states:
"CrystalDecisions.CrystalReports.Engine.LogOnException: Logon Failed"

Any help would be greatly appreciated.

Thanks,

Mike Q.

| [ngfx-crystal] member Click here to reveal e-mail address = YOUR ID
| http://www.aspfriends.com/aspfriends/ngfx-crystal.asp = JOIN/QUIT
Reply to this message...
 
    
Tiffany Cynor
I am having the same problem in my App. I connected fine to our MS SQL database. I'm having a problem connecting to our postgres database though. When I create my ODBC connection I can pick and choose tables & fields from the DB with no problem. The Login error occurs when I try to run the project. Please help.

--------------------------------
From: Tiffany Cynor
Reply to this message...
 
    
Shaun Donaghy
** Before acting on this e-mail or opening any attachments please be advised to read Walker Morris' disclaimer at the end of this e-mail **
____________________________________________________________

You need to add a sql login and password in the database connection string.
Windows authentication won't work.

-----Original Message-----
From: Wolfgang Baeck [mailto:Click here to reveal e-mail address]
Sent: 18 July 2002 01:22
To: ngfx-crystal
Subject: [ngfx-crystal] RE: CrystalReports: Logon Failed

Same here and I haven't found a resolution yet. My interim solution is to install the old crystal report page server (no licensing issue there!!), and put the .rpt files into a separate directory from where I request them.

Advantage: Simple word and excel export along with printing due to client side viewer (java or activex)

If you find a solution, please pass it on.

Wolfgang

-----Original Message-----
From: Quale, Michael [mailto:Click here to reveal e-mail address]
Sent: Wednesday, July 17, 2002 1:45 PM
To: ngfx-crystal
Subject: [ngfx-crystal] CrystalReports: Logon Failed

We are creating our first Crystal Reports in VS.NET today! Yee Haa! Anyway, we have had no problems connecting to the sample database and generating the sample rpt's. They work great. The problem is when we try to create our own rpt's within our project and try to connect to a non-local database we get an error which states:
"CrystalDecisions.CrystalReports.Engine.LogOnException: Logon Failed"

Any help would be greatly appreciated.

Thanks,

Mike Q.

| [ngfx-crystal] member Click here to reveal e-mail address = YOUR ID
| http://www.aspfriends.com/aspfriends/ngfx-crystal.asp = JOIN/QUIT

| [ngfx-crystal] member Click here to reveal e-mail address = YOUR ID
| http://www.aspfriends.com/aspfriends/ngfx-crystal.asp = JOIN/QUIT

***************************************************

Notice
Walker Morris is regulated by the Financial Services Authority for investment business. A list of the partners' names is open to inspection at Kings Court, 12 King Street, Leeds, LS1 2HL.

Private and Confidential
This e-mail may contain information that is privileged, confidential or otherwise protected from disclosure. It must not be used by, or its contents copied or disclosed to persons other than the intended recipient. However, the contents of this e-mail may be intercepted, monitored or recorded for training or compliance purposes. Any liability (in negligence or otherwise) arising from any third party acting, or refraining from acting, on any information contained in this e-mail is excluded.

If you have received this e-mail in error please notify our Systems Administrator on +44 (0)113 2832500 and delete the e-mail.

Warning
It is the responsibility of the recipient to ensure that the onward transmission, opening or use of this message and any attachments will not adversely affect its systems or data. Please carry out such virus and other checks as you consider appropriate. No responsibility is accepted by Walker Morris in this regard.

Copyright
Copyright in this e-mail and any attachments created by Walker Morris belongs to Walker Morris.

**************************************************
Reply to this message...
 
    
Eric Landes (VIP)
Michael,
Could you please post your code? That could help us see where the =
problem is
at.

Thanks=20
*************************=20
Eric Landes=20
Senior Programmer/Analyst member of the ASPFriends.com Moderator team=20
For Articles on Crystal.Net, Datagrids and more check out
http://www.aspalliance.com/corporatecoder/
*************************=20
All statements expressed are my own, and do not reflect the opinion of =
my
employer, unless stated otherwise.=20

-----Original Message-----
From: Quale, Michael [mailto:Click here to reveal e-mail address]
Sent: Wednesday, July 17, 2002 2:45 PM
To: ngfx-crystal
Subject: [ngfx-crystal] CrystalReports: Logon Failed

We are creating our first Crystal Reports in VS.NET today! Yee Haa!
Anyway, we have had no problems connecting to the sample database and
generating the sample rpt's.
They work great.
The problem is when we try to create our own rpt's within our project =
and
try to connect to a non-local database we get an error which states:=20
"CrystalDecisions.CrystalReports.Engine.LogOnException: Logon Failed"

Any help would be greatly appreciated.

Thanks,

Mike Q.

Confidentiality Notice: This e-mail message, including any
attachments, is for the sole use of the intended recipient(s) and may
contain confidential and privileged information. Any unauthorized
review, use, disclosure or distribution is prohibited. If you are not
the intended recipient, please contact the sender by reply e-mail and
destroy all copies of the original message.

PARTNERS Health Plan Phone: 574-233-4899
100 E. Wayne St., Suite 502 Fax: 574-234-7484
South Bend, IN 46601 www.partnersindiana.com
Reply to this message...
 
    
Quale, Michael
Eric, actually I just solved it this morning.

Earlier, Shaun suggested the following:

"You need to add a sql login and password in the database connection string.
Windows authentication won't work."

I also found similar suggestions and code examples off Google that said the
same thing. The problem was even after doing that I was still getting the
same error.

The Problem:
I was setting the ConnectionInfo.ServerName = "the server name" which the
examples
were showing.

The Solution:
I changed the ConnectionInfo.ServerName = "the OLE provider name" or the
name of
my OLE connection and that did it. "It's all good!"

Thanks for the advise and help!

Now I just have to figure out how to make these reports look good!

Thanks again,

Mike Quale

Michael Quale
Web Developer
American Imaging Management, Inc.

[E] Click here to reveal e-mail address
[P] 847.559.6523
[F] 847.559.6900

-----Original Message-----
From: Eric Landes [mailto:Click here to reveal e-mail address]
Sent: Thursday, July 18, 2002 8:19 AM
To: ngfx-crystal
Subject: [ngfx-crystal] RE: CrystalReports: Logon Failed

Michael,
Could you please post your code? That could help us see where the problem is
at.

Thanks
*************************
Eric Landes
Senior Programmer/Analyst member of the ASPFriends.com Moderator team
For Articles on Crystal.Net, Datagrids and more check out
http://www.aspalliance.com/corporatecoder/
*************************
All statements expressed are my own, and do not reflect the opinion of my
employer, unless stated otherwise.

-----Original Message-----
From: Quale, Michael [mailto:Click here to reveal e-mail address]
Sent: Wednesday, July 17, 2002 2:45 PM
To: ngfx-crystal
Subject: [ngfx-crystal] CrystalReports: Logon Failed

We are creating our first Crystal Reports in VS.NET today! Yee Haa!
Anyway, we have had no problems connecting to the sample database and
generating the sample rpt's.
They work great.
The problem is when we try to create our own rpt's within our project and
try to connect to a non-local database we get an error which states:
"CrystalDecisions.CrystalReports.Engine.LogOnException: Logon Failed"

Any help would be greatly appreciated.

Thanks,

Mike Q.

Confidentiality Notice: This e-mail message, including any
attachments, is for the sole use of the intended recipient(s) and may
contain confidential and privileged information. Any unauthorized
review, use, disclosure or distribution is prohibited. If you are not
the intended recipient, please contact the sender by reply e-mail and
destroy all copies of the original message.

PARTNERS Health Plan Phone: 574-233-4899
100 E. Wayne St., Suite 502 Fax: 574-234-7484
South Bend, IN 46601 www.partnersindiana.com

| [ngfx-crystal] member Click here to reveal e-mail address = YOUR ID
| http://www.aspfriends.com/aspfriends/ngfx-crystal.asp = JOIN/QUIT
Reply to this message...
 
    
Wolfgang Baeck
Shaun,

Here is the code that I'm using. I have put login information anywhere I
could think of and found no solution.

-----------------------------------------------------------------------
using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using CrystalDecisions.Shared;
using CrystalDecisions.CrystalReports.Engine;

namespace HopeAndHome.Admin
{
    public class PlacementHistory : System.Web.UI.Page
    {
        protected CrystalDecisions.Web.CrystalReportViewer CrystalReportViewer1;
        // CR variables
        HopeAndHome.Admin.Reports.PlacementHistory crReportDocument;
        Database crDatabase;
        Tables crTables;
        TableLogOnInfo crTableLogOnInfo;
        ConnectionInfo crConnectionInfo;

        private void Page_Load(object sender, System.EventArgs e)
        {
            //Create an instance of the strongly-typed report object
            crReportDocument = new HopeAndHome.Admin.Reports.PlacementHistory();

            //Create a new instance of the connectioninfo object and
            //set its properties

            crConnectionInfo = new ConnectionInfo();
            crConnectionInfo.ServerName = "metaphor-lt1";
            crConnectionInfo.DatabaseName = "HopeAndHome";
            crConnectionInfo.UserID = "userid";
            crConnectionInfo.Password = "password";

            //Get the tables collection from the report object
            // Note, I have no collection of tables in the report object, therefore
this
could be the culprit but it doesn't work with reports on tables either
            crDatabase = crReportDocument.Database;
            crTables = crDatabase.Tables;

            //Apply the logon information to each table in the collection
            // there seems to be no foreach ...Engine.StoredProcedure ???
            foreach (CrystalDecisions.CrystalReports.Engine.Table crTable in
crTables)
            {
                crTableLogOnInfo = crTable.LogOnInfo;
                crTableLogOnInfo.ConnectionInfo = crConnectionInfo;
                crTable.ApplyLogOnInfo(crTableLogOnInfo);
            }
            //Once the connection to the database has been established for
            //each table in the report, the report object can be bound to the viewer
            //using the reportsource property of the viewer to display the report.
            CrystalReportViewer1.ReportSource = crReportDocument;
        }

        #region Web Form Designer generated code
        override protected void OnInit(EventArgs e)
        {
            //
            // CODEGEN: This call is required by the ASP.NET Web Form Designer.
            //
            InitializeComponent();
            base.OnInit(e);
        }

        /// <summary>
        /// Required method for Designer support - do not modify
        /// the contents of this method with the code editor.
        /// </summary>
        private void InitializeComponent()
        {
            this.Load += new System.EventHandler(this.Page_Load);

        }
        #endregion
    }
}

-----Original Message-----
From: Shaun Donaghy [mailto:Click here to reveal e-mail address]
Sent: Thursday, July 18, 2002 1:49 AM
To: ngfx-crystal
Subject: [ngfx-crystal] RE: CrystalReports: Logon Failed

** Before acting on this e-mail or opening any attachments please be advised
to read Walker Morris' disclaimer at the end of this e-mail **
____________________________________________________________

You need to add a sql login and password in the database connection string.
Windows authentication won't work.

-----Original Message-----
From: Wolfgang Baeck [mailto:Click here to reveal e-mail address]
Sent: 18 July 2002 01:22
To: ngfx-crystal
Subject: [ngfx-crystal] RE: CrystalReports: Logon Failed

Same here and I haven't found a resolution yet. My interim solution is to
install the old crystal report page server (no licensing issue there!!), and
put the .rpt files into a separate directory from where I request them.

Advantage: Simple word and excel export along with printing due to client
side viewer (java or activex)

If you find a solution, please pass it on.

Wolfgang

-----Original Message-----
From: Quale, Michael [mailto:Click here to reveal e-mail address]
Sent: Wednesday, July 17, 2002 1:45 PM
To: ngfx-crystal
Subject: [ngfx-crystal] CrystalReports: Logon Failed

We are creating our first Crystal Reports in VS.NET today! Yee Haa! Anyway,
we have had no problems connecting to the sample database and generating the
sample rpt's. They work great. The problem is when we try to create our own
rpt's within our project and try to connect to a non-local database we get
an error which states:
"CrystalDecisions.CrystalReports.Engine.LogOnException: Logon Failed"

Any help would be greatly appreciated.

Thanks,

Mike Q.

| [ngfx-crystal] member Click here to reveal e-mail address = YOUR ID
| http://www.aspfriends.com/aspfriends/ngfx-crystal.asp = JOIN/QUIT

| [ngfx-crystal] member Click here to reveal e-mail address = YOUR ID
| http://www.aspfriends.com/aspfriends/ngfx-crystal.asp = JOIN/QUIT

***************************************************

Notice
Walker Morris is regulated by the Financial Services Authority for
investment business. A list of the partners' names is open to inspection at
Kings Court, 12 King Street, Leeds, LS1 2HL.

Private and Confidential
This e-mail may contain information that is privileged, confidential or
otherwise protected from disclosure. It must not be used by, or its
contents copied or disclosed to persons other than the intended recipient.
However, the contents of this e-mail may be intercepted, monitored or
recorded for training or compliance purposes. Any liability (in negligence
or otherwise) arising from any third party acting, or refraining from
acting, on any information contained in this e-mail is excluded.

If you have received this e-mail in error please notify our Systems
Administrator on +44 (0)113 2832500 and delete the e-mail.

Warning
It is the responsibility of the recipient to ensure that the onward
transmission, opening or use of this message and any attachments will not
adversely affect its systems or data. Please carry out such virus and other
checks as you consider appropriate. No responsibility is accepted by Walker
Morris in this regard.

Copyright
Copyright in this e-mail and any attachments created by Walker Morris
belongs to Walker Morris.

**************************************************

| [ngfx-crystal] member Click here to reveal e-mail address = YOUR ID
| http://www.aspfriends.com/aspfriends/ngfx-crystal.asp = JOIN/QUIT
Reply to this message...
 
    
Tzury Bar Yochay
Well, so far (ver 9.1 with VS.Net 2003) I couldn not come up with a better solution than using OLEDB driver instead of ADO.NET!
The only way to make it working is that way.
This bring over limitations especially if you want to consume the report as Web Service.

--------------------------------
From: Tzury Bar Yochay
Reply to this message...
 
    
Mary Segura
(Type your message here)

--------------------------------
From: Mary Segura

we were encountering a similar problem. To resolve the problem, use the following

CReport1 qReport = new CReport1();
qReport.SetDatabaseLogon("user","password","server","database");
CrystalReportViewer1.ReportSource = qReport;
Reply to this message...
 
 
System.EventArgs
System.EventHandler
System.Web.UI.Page




ExamGuru IT Solutions - .Net Guru is owned and operated by ExamGuru, Inc., the man behind .Net Guru. If you're in the market for bespoke software or software consultancy, why not get him and his highly trained team to help? - www.examguru.net/ITCertification
Ad


Need Dot Net Interview Questions?
Ask ExamGuru, Inc. for advice and help on Passing .Net Interviews
.Net Projects
Best-of-breed application framework for .NET projects, developed by ExamGuru, Inc. and ExamGuru IT
Free .net Help
Commission ExamGuru, Inc. and his team for your next bespoke software project
FogBUGZ
The only bug tracking system carefully crafted with one goal in mind: helping teams create great software.
Awesome Tools
If you don't know about these, you're missing out... IT Certification Questions
IT Interview Questions
Free Oracle 10g Training
MCSE Boortcamp
Cisco Study Guides
Cheap Study Guides
Exact Questions
Dot Net Interview Questions
Oracle OCP
Cheap Travel
Designer Perfumes - Wholesale Prices
Free Programming Tutorials
 
ExamGuru IT Solutions - .Net Guru is owned and operated by ExamGuru, Inc., the man behind .Net Guru. If you're in the market for bespoke software or software consultancy, why not get him and his highly trained team to help? - www.examguru.net/ITCertification
 Copyright © ExamGuru, Inc. 2001-2006
Contact Us - Terms of Use - Privacy Policy - www.dot-net-guru.com - www.examguru.net - www.oraclesource.net - www.itinterviews.net - www.examguru.net/ITCertification