×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Crystal Reports Viewer keeps asking for database password.

Crystal Reports Viewer keeps asking for database password.

Crystal Reports Viewer keeps asking for database password.

(OP)
Using CR XI connecting to a MSSQL 2008R2 Standard database.

Ive created a report with a subreport which everything works fine from Crystal Reports. I save the .rpt file to a file location for the application to call from, using crystal reports viewer. For whatever reason, the viewer keeps asking for the username and password for the database (ODBC connection). I cannot select the "save data with report" option, because I need the report to always call the parameters first. Selecting the "save data with report" option does work in regards to not asking for any credentials.

I believe I'm just missing something simple, but not sure what. I can provide more report details if you feel the report design is causing the issue.

RE: Crystal Reports Viewer keeps asking for database password.

You cannot save the user name and password with the report (except you use integrated security). Are you setting them from the calling application ?

www.R-Tag.com   Viewer, scheduler and manager for Crystal reports.
Send your report everywhere.

RE: Crystal Reports Viewer keeps asking for database password.

(OP)
The calling application uses the same DSN as the report. Same username and password in the DSN.

RE: Crystal Reports Viewer keeps asking for database password.

You cannot save username and password in the DSN.

www.R-Tag.com   Viewer, scheduler and manager for Crystal reports.
Send your report everywhere.

RE: Crystal Reports Viewer keeps asking for database password.

Do you have the report in the Central Management Console (CMC)? If so, right click on the report in CMC and select "Database Configuration".

If you want the user to use the same username/password as the datasource, select "Use same database logon as when report is run" at the bottom of the page.

 

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close