sa login prompt

[HFTHdfries]

We just added a password to the "sa" account on our SQL server. Now all the reports published on our intranet prompt our users for a username and password (this was not the case before). I've tried changing the ODBC connection to NT authentication and I've tried adding in our password under SQL authentication. I am not using Eportfolio - I link directly through a URL like

http://www.samplecompany.com/reports/samplereport.rpt

Could someone give me some advice on this issue?

Thanks,
Dan

 

[bdreed35]

Dan:

Try repointing your report to the ODBC DSN in Crystal Reports and then running your report again. Also, check out CD's Knowledge Base. You may be having what they call a looping logon.

http://support.crystaldecisions.com

~Brian

 

[HFTHdfries]

Thanks for your help. I decided to use Crystal Enterprise eportfolio since it allows me to put in a default database logon.