Crystal Server XI, MS Access Report, Username & Password problem

[random621]

I am demoing Crystal Server XI, with Crystal Reports Developer XI for report editing.

I have shared a simple report that reports off a MS Access 2002 database. I setup the report as an Object in the Central Management Console.

When I try to access the report from a client PC using info view or even try to preview the report from within Central Management Console, I get the prompt for Database Logon (The report you requested requires further information).

Problem is the Access report doesn't have a password on it and when I run the report from within the actual Crystal Reports program you never get prompted for password.

I have tried setting the password to admin and <blank> on the Database Logon screen in info view. I have tried assigned the access database a password (for admin) and then using that combo - no luck.

I'm sure I'm missing something simple, but no idea what it is.

Also - I have a version of the same report (in Crystal 8.5) that some people in the office here access via a program called cView. When you first run the report in cView it prompts for username and password and after setting both to blank the report runs fine. I have tried blank usename and password in CR XI, but that doesn't work.

 

[bdreed35]

What account is the Crystal Page Server running under?
It is probably still under the the default System account and needs to be changed to a domain account that has permissions to access the network folder that contains the Access database.

You can change the account for the Crystal Page Server by using the Central Configuration Manager to stop the service, change the account, and then restart it.

~Brian

 

[random621]

Brian -

Thanks for the reply. I set the page server to be started by one of our domain admin accounts. Still no luck. Are there other servers that need to be started by a domain account vs local system account?

Maybe another bit of helpful information, when I log onto info view to run the report - I am logging onto "Enterprise" and not my active directory. Maybe this is the problem? When I do try to log onto info view as an active directory account, it says plugin no installed. Any idea what plugin that might be?

Ryan

 

[chelseatech]

If the access database is on a remote machine, you will need to use a UNC location. Windows services cannot see mapped drives, so any MDB location using that will have connectivity problems.

Editor and Publisher of Crystal Clear

http://www.chelseatech.co.nz/pubs.htm

 

[random621]

Chelseatech -

Thanks for the info. At first I didn't think this would work, but then I realized I was approacing the issue wrong. When you mentioned I needed to use UNC, what I did was change my ODBC source that connects to this database to use UNC path, which did not resolve the problem.

So then I built a new report, using "Create New Connection" and "Database Files" and then linked the file in that wizard via UNC. This time the report worked in InfoView.

Any idea why using an ODBC connection with UNC path does not work?

I have only worked with Crystal Reports 8.5 in the past and not in the "Enterprise" model, in the past using ODBC connectors has always worked for me. Is there some reason with Crystal XI server that I should avoid this?