Crystal Reports is prompting for credentials to the database the report is pulling information from

[former_member709215]

We have a particular Crystal Report that is prompting for credentials to the database the report pulls information from. Can you please tell me how to prevent this from happening? Thank you!

[ido_millet]

Just to avoid confusion, Don probably meant "NT Authentication" in his answer above.

You may need to contact the developer of your viewer software for an answer to this.

[former_member709215]

We are running the report using the Logicity Crystal Report viewer and Crystal Reports 2016 version.

[former_member11696]

Use MS SQL Server Authentication, as long as the User has permissions to access the database then it won't prompt for a password.

CR will then pass the User name, that he's logged into his PC, to MS SQL Server and will authenticate based on his user credentials.

If it's not MS DB then there are other security options you can use.

Basically CR doesn't save the password in the RPT file, that would be a huge security problem, user could just edit the report and do all sorts of damage to the DB.

If you configure the DB using it's or a 3rd party security feature then CR will not prompt for the log on info. It'll be that 3rd party client option doing the verification.

When creating the report check on the option to DB Authentication

[DellSC]

How are you running the report? If it's being run within Crystal, there is no way to prevent this as Crystal doesn't save the password.

-Dell

[vitaly_izmaylov]

Technically it is possible in Crystal Reports by using ODBC Connection String, but it is insecure as the password would be exposed in open text.