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?
LVL 1
sjjcatAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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
Powerful Yet Easy-to-Use Network Monitoring

Identify excessive bandwidth utilization or unexpected application traffic with SolarWinds Bandwidth Analyzer Pack.

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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Crystal Reports

From novice to tech pro — start learning today.