Database Logon required

[BrianLi]

I am new to CE. I have an Access 2000 database located at a network folder. There is no security setting for the access database. I create a report using Crystal Report 9.0 and I can run the report without problem. When I publish this report to CE and view the report from ePortfilio, I got message said "The report you requested requires further information." The detail is:

Database Logon
Database Logon - \\Mdfs1Jobs\

http://www\ADESA\Data\ADESAtrackingtool.mdb

Server Name \\Mdfs1Jobs\

http://www\ADESA\Data\ADESAtrackingtool.mdb

Database Name \\Mdfs1Jobs\

http://www\ADESA\Data\ADESAtrackingtool.mdb

User Id :
Password :

The database doesn't have user id and password. Could you help me how solve the problem?

I realy appreciate your kind of help.

Brian

 

[cjlarue]

When you published the report and set the database information did you check "Prompt the user for database logon when viewing". Take a look in the Crystal Management Consol at your report and look at the settings for database. Can you run the report from the CMC (Crystal management consol)?


Regards
Chuck LaRue
ADRS Computer Services

 

[BrianLi]

Thanks for the reply. When I publish the report, I didn't check the "Prompt the user for database logon when viewing". The setting for the database is "Use original database logon information from the report" in CMC

I got the same logon required message if I run from the CMC.

Brian

 

[cjlarue]

Just created a quick CR9 report from Access and published to CE. Runs as expected without prompt. In the CR designer do you have verify on refresh checked. Not sure if this would cause the prompt for access DB but it has caused me other issues. Also is data saved with report checked?


Regards
Chuck LaRue
ADRS Computer Services

 

[cjlarue]

I was able to reproduce you error by moving the DB to another folder. Make me think that CE cannot see the network folder.


Regards
Chuck LaRue
ADRS Computer Services

 

[BrianLi]

Thanks a lot again for your reply. In the CR designer, I did have "first verify on refresh" checked. If unchecked the "first verify on refresh" and republished to CE, I got the same logon required prompt for the database.

Thanks
Brian

 

[BrianLi]

Hi chuck,

Could you tell me how you set up your CE and CR?

My setting is:
CE is at IIS web server and Crystal report at my local workstation.

Thanks.

Brian

 

[cjlarue]

I have several combinations available. The sample I ran used CR9 advanced to created the access report against a DB on my local C: drive. I have CE9 Pro installed on this same machine for testing and Dev. My Dev box is WinXP Pro runnign IIS 5 as the web server.


Regards
Chuck LaRue
ADRS Computer Services

 

[BrianLi]

I solve this problem. Thank a lot for the experts who post their idea. The solution is that I create an access database on CE server and link the remote table in the network. Update the database location of the report and republish to CE.

Howerver, I got another error message and I will post it in different subject.

Thanks again.

Brian

 

[bdreed35]

You shouldn't have to create an extra database for this.

Chuck eluded to the fact that CE probably couldn't see your network folder. What kind of account is the Page Server and Job Server running under? This account needs to have permissions to access the network that your database is stored on. You are using UNC naming so you are good there. Can you navigate to the Mdfs1Jobs machine from the CE server?

~Brian

 

[cjlarue]

Another thought. Rather than hitting the mdb directly, create a system DSN and use ODBC to connect to the data. then just put the same DSN on the CE server.


Regards
Chuck LaRue
ADRS Computer Services

 

[aschadek]

I have run into the same issue BrianLi did, however, I was already using an ODBC connection to connect to the database. I recently upgraded from CERAS9 to the full blown version of CE9. The report ran perfectly in CERAS9, but now I receive then annoying looping login prompt. Is there something I missed when setting up CE9? Can anyone think of a reason that I was able to connect to the data prior to the upgrade?

Here is some information that I hope will prove helpful.
O/S: Windows 2000 - Small Business Server
SQL: SQL Server Desktop Engine(MSDE 2000 free install from Microsoft)
Crystal products used: Crystal Enterprise 9, Crystal Reports 9

Please let me know if you need any more information about how I set up the system, etc. Any help anyone can offer is greatly appreciated. I've searched high and low for a solution for this problem but to no avail.

Thanks,
Alex Schadek
Disaster Restoration Inc.

 

[SonOfZeus]

The report you requested requires further information" - prompt when report contains a subreport.

I've populated a dataset and it works perfectly with a basic Crystal report. The problem I'm having is when I want this same dataset to be used within a subreport (i.e. Invoice & details) I get the message above when I run, asking for server, user... The issue is that I've already got the disconnected dataset, I don't want extra calls to the data server. Any idea what may be wrong?