Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

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

Access to Crystal Report As Web Service - Logon Failed

I have 2 test PC's setup in the office. Both have MS DevStudio 2003, Crystal 10 (for .Net) installed.

On one PC I developed VB.Net WebService project, exposing a single report as a WebService.  It takes no params & queries a local SQL Server 2000 DB.

On the other PC I created a consumer (client)  VB.Net WebApp.  In the VS IDE on the client PC, I have a report viewer which has the databindings set to "http://<Server IP>/WebRep/ReportService.asmx"

In the VS IDE of the client PC,  I can actually see the generated report in the viewer (compile time).  However, when I run the app, I receive the message "Database Logon Failed."  So I tried:

1)  On the server, I gave ASPNET & IUSR ownership rights to the SQL Server database.  This is intranet only, I wouldn't actually leave it this way :-)
2)  In machine.config I changed username from 'machine' to 'Admin equivalent' with matching password.  
3) Gave 'Admin equivalent' Windows account ownership/Admin rights to database.  
4) Restarted IIS.

None of these helped.  Do I need to set logon info for the ReportViewer?  Is there another step I'm missing?  


  • 2
1 Solution
Glad i could help


Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

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