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://
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?