Crystal Reports Viewer keeps asking for database password.

[jlopeman]

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.

 

[RTag]

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

http://www.R-Tag.com

Viewer, scheduler and manager for Crystal reports.
Send your report everywhere.

 

[jlopeman]

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

 

[RTag]

You cannot save username and password in the DSN.

http://www.R-Tag.com

Viewer, scheduler and manager for Crystal reports.
Send your report everywhere.

 

[Jetter88]

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.