Logon failed. Crystal Reports .NET 
Author Message
 Logon failed. Crystal Reports .NET

I have the exact same "Logon failed" problem with Crystal Reports .NET. It
works fine when I use SQL Authentication but it fails with Windows
Authentication connecting to a remote SQL server. I have to use Windows
Authentication because we are impersonating the user at IIS before
connecting to the SQL server.

I added the ASPNET user and our impersonated user to the database with the
public, owner, reader and writer permissions but it didn't make any
difference. I defined a DSN for the connection, and used it rather than
making an OLEDB connection but it didn't help either. The connection is all
right during design-time but it fails at run-time.

I know that this problem has already been mentioned in different newsgroups
with several workarounds that I compiled in the previous paragraph. However,
neither of them solved my problem.

Thanks in advance,

> Anders,

> I think I have finally found your problem. Are you by any chance using
> Integrated Security? If so you need to make sure that the ASPNET user on
> the webserver has access to the SQL database.

> I was able to replicate the error that you described. And by adding the
> ASPNET user to the database, and for testing purposes I gave it owner
> access, the report ran successfully.

> Hope this is of some help to you.

> Robert Johnson
> Microsoft ASP.NET Developer Support

> This posting is provided "AS IS" with no warranties, and confers no

> --------------------
> Content-Class: urn:content-classes:message

> I'm successfully able to display reports in a ASP.NET page
> (VS.NET final version)
> The SQL datasource is an Access or another source without
> password.
> However when i'm changing database source to Oracle or
> SQL2000 server, the
> ASP.NET page will throw an exception (see below).
> Now, I know that the DB connect is successful as a it
> connects properly in design mode
> and displays data and tables in design mode. However, when
> browsing it will generate the following error:
> -----------------------------------------------------------
> Logon failed.
> Description: An unhandled exception occurred during the
> execution of the current web request. Please review the
> stack trace for more information about the error and where
> it originated in the code.
> Exception Details:
> CrystalDecisions.CrystalReports.Engine.LogOnException:
> Logon failed.
> Stack Trace:
> [LogOnException: Logon failed.]
>     . K(String  
> , EngineExceptionErrorID  
> ) +546
>     . F(Int16   , Int32   ) +491

> CrystalDecisions.CrystalReports.Engine.FormatEngine.GetPage
> (PageRequestContext reqContext) +459

> CrystalDecisions.ReportSource.LocalReportSourceBase.GetPage
> (PageRequestContext pageReqContext) +189
>    CrystalDecisions.Web.ReportAgent.v(Boolean  `) +150
>    CrystalDecisions.Web.CrystalReportViewer.OnPreRender
> (EventArgs e) +108
>    System.Web.UI.Control.PreRenderRecursiveInternal() +62
>    System.Web.UI.Control.PreRenderRecursiveInternal() +125
>    System.Web.UI.Control.PreRenderRecursiveInternal() +125
>    System.Web.UI.Page.ProcessRequestMain() +1470
> -----------------------------------------------------------
> I suspect that the Database username and password is not
> stored in the report, so i'll
> have to provide this at runtime. Now, how will i do this??
> Thanks,
> Anders

Tue, 14 Sep 2004 23:14:38 GMT  
 [ 1 post ] 

 Relevant Pages 

1. Logon Failed.. Crystal Reports.Net Error (Code Included)

2. Crystal Report in .NET - Logon Failed Error while Exporting

3. FYI - Logon Failed in Crystal.Net having Subreports (Working Code Supplied)

4. Crystal and .NET: Logon failed

5. .Net Crystal Viewer Logon Failed

6. dot net logon failed in sub reports

7. Desperately Need HELP!!!!-Crystal Report-Logon Fail - Can anyone even give me a lead

8. Help-"Error5-Logon Failed"-HELP PLease!!!!!!-Crystal Report

9. Logon Failed when exportign crystal report to PDF (or any other format)

10. Logon Failed For Crystal Reports

11. Crystal Reports 8.5 (VB6) to Crystal Reports NET (VB.NET) conversion

12. cr.net - Logon Failed


Powered by phpBB® Forum Software