The environment I'm working in is a Crystal Reports Server 2008 talking to a MySQL Server 5.1 database using JDBC.

The problem is that I get a database logon screen every time I try to access a report from Crystal Reports Server.

I've setup a JDBC connection using the MySQL Connector/J driver. When I create a .rpt file I provide the login credentails all is fine. I then publish to InfoView and go to access the report and it prompts me for username and password to the database. I then went to CMC and right-clicked on the report and opened the Database Configuration. I've selected 'Use original database logon information from the report' and 'Use same database logon as when report is run'. However, I still get the logon screen when I try to access the report.