Silent DSN for Crystal

[LouieGrandie]

I have a Crystal report that uses SQL as the data source. I am going to use a business monitoring software to run and distribute the report. My problem is that I need a "silent" DSN so that when there is no log in prompt for SQL. How would I do that? The DSNs I have created don't see to hold the password when I save it.

Visit Sage's Online Community

http://community.sagemas.com/sagemas/?category.id=SageMAS90and200Disc

 

[PeterDimitrov]

The connection should be handled by the software, which is running the report. The data in DSN files is plain text and if the password is saved inside this will compromise the security. You can use Integrated security and handle users permissions on the database side. If you need to use password find software , which is able to set the report connection. There are plenty of report schedulers , which are able to do this. Check this comparison :

http://kenhamady.com/cru/comparisons/desktop-scheduling-engines

What kind of software are you planning to use ?

http://www.R-Tag.com

Viewer and Scheduler for Crystal reports, SSRS and Dynamic Dashboards.