More Logon Failed exceptions

Good Morning,
   I have been monkeying about with the CR.Net stuff, and in a normal winform client can load a report that talks to an Access database via a DSN connection. However, that same report with virtually the same code will NOT load in a web application. It constantly gives me the logon failed exception:

[LogOnException: Logon failed.]
   . F(String , EngineExceptionErrorID
)
   . A(Int16 , Int32 )
   . @(Int16 )
   CrystalDecisions.CrystalReports.Engine.FormatEngine.GetPage(PageRequestContext reqContext)
   CrystalDecisions.ReportSource.LocalReportSourceBase.GetPage(PageRequestContext pageReqContext)
   CrystalDecisions.Web.ReportAgent.u(Boolean N)
   CrystalDecisions.Web.CrystalReportViewer.OnPreRender(EventArgs e)
   System.Web.UI.Control.PreRenderRecursiveInternal()
   System.Web.UI.Control.PreRenderRecursiveInternal()
   System.Web.UI.Control.PreRenderRecursiveInternal()
   System.Web.UI.Page.ProcessRequestMain()

This led me to believe it is a permissions issue with the .mdb file. So I adjusted the NTFS permissions on the file and its parent directory to include full control for both the IUSR and ASPNET accounts. The error persists. Please note this issue ONLY occurs for reports that talk to Access files, NOT SQL Server2k dbases.

Any advice would be much appreciated.

Thanks,
Chad

Answer this question

More Logon Failed exceptions

crazylady
Hello Chad,

A couple of questions:

- which version of Crystal Reports are you using
- are the report and the database in the same directory
- is there MS Access security applied to this database
- what type of directory security is IIS using

Keith - Business Objects
Gus Crawford
Thank you very much. I appreciate the help.
PremP
As stated above, I have tried the report and database in the same directory, in different directories, etc. The database and report both sit on my local machine. The DSN is a System DSN, as pretty much all DSN's used by web services are (at least in our environment).

I just attempted with the Xtreme Sample and get the same error. I left the mdb where it was so I did not alter the DSN, placed the report in my web app directory and ran it. No dice. Same Logon Exception error as above.

Just as a lark I ran the same report with the same code in a vb app, rather than web app and once again the report loads fine.

As to the KB article you gave me: it does not apply. I am not getting the same error messages reported in the article, nor is my dbase on a different system.
congnv
I am using the version installed with VS.NET 2003. Can't remember how to get actual version info out of the embedded version, sorry.

I have tried the DB and report in the same directory, in different directories, etc. Either way, I am accessing the DB via an ODBC DSN. Since it is ODBC, should it make a difference where the files sit It doesnt with normal ODBC data source, at least in my experience. If you prefer the mdb sit in a certain folder whilst we work, I can do that, but as in a normal production environment, I will have need to report from varying mdb files that cannot all sit in one place- Will this be an issue for reporting

There is no MS Access security on the DB.

As for IIS, it is using Anonymous access, with the IUSR account. Where Authenticated access is required it is using integrated WIndows Auth.
Mike @ DanRic
I did find this one KBase article - it seems to related to mapped drives:

http://support.businessobjects.com/library/kbase/articles/c2012606.asp

Is the that database on the development machine

Is the ODBC DSN a User DSN or System DSN

Have you tried using our sample reports as a test There is the World Sales Report and it uses the Xtreme Sample Database DSN.

If the sample works then we can narrow it down to something specific about your database/dsn/report.

Keith - Business Objects
idrissbahhussein
Since you are getting the same error with our sample Xtreme database my guess is that it is a rights issue with ASP.NET.

There are a lot of things to work through in these situations so I would recommend that you contact support.

http://support.businessobjects.com/fix/contact.asp

You do get 2 free online support incidents if you register the product.

Keith - Business Objects
More Logon Failed exceptions

Answer this question