• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 519
  • Last Modified:

Crystal Report in web application will not run - shows error: Report was not cached successfully - Database logon failed

I write a report in Crystal XI and I use ODBC to connect to a SQL database.
I use Integrated Security and the report runs ok in Crystal.
I import the report into the web application and attempt to run it.
The error displays:
Report was not cached successfully - Database logon failed
I go back to my report and change from Integrated to a SQL login, again it runs successfully in Crystal, but when I try and run it via the web app, the same message appears.

The error in the log is:
CrystalDecisions.CrystalReports.Engine.LogOnException: Database logon failed. ---> System.Runtime.InteropServices.COMException (0x8004100F): Database logon failed.

I am not sure what security I should be using as neither seems to be working. Any ideas?
0
sjjcat
Asked:
sjjcat
  • 5
  • 3
1 Solution
 
mlmccCommented:
Are you installing the Crystal merge modules on the server?
It sounds like you are missing the database connection dlls.

mlmcc
0
 
sjjcatAuthor Commented:
How would I see if these exist on the server?
I installed Crystal 11 .Net plus the app, plus Crystal Reports so I can write a report and embed it. All other  components of the app work ok.
Thanks
0
 
mlmccCommented:
You installed those on the server or your development machine?

mlmcc
0
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

 
sjjcatAuthor Commented:
This is a server we use for demonstrations of the product.  
0
 
sjjcatAuthor Commented:
This is interesting.
Usually when I set up this app I give two users access to the DB, as I understand the app runs the report under this name.
servername/aspnet
servername/network service

It was my understanding one version of asp.net used aspnet and one used network service, if noth users existed I would add both.

On this server network service does not exist. Why would that be?  Is that user needed?  Could that be why the database login is failing?  How do I add Network Service? Is there something missing?
0
 
mlmccCommented:
Could be.  I don't know how to add the servers.

mlmcc
0
 
sjjcatAuthor Commented:
Do you know how the Network Service user gets added?
0
 
sjjcatAuthor Commented:
This has been fixed.  It was fixed by reinstalling aspnet (saw this on another post).
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

  • 5
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now