Crystal Reports 11, how to save SQL connection password?

Posted on 2006-06-04
Last Modified: 2008-02-01
Hi, for security and networking reasons I'm using an OLE-ADO connection to MS-SQL 2005 with an explicit SQL user (that has read only access to the tables needed). The report is published on a webserver (via an ASP.NET 2.0 website), and I need to hardcode the connection password within the report. How can I do that?



Question by:TerryBurger
    LVL 100

    Expert Comment

    I am not that familiar with the ADO connection method but don't you open the connection in the ASP application then bind it to the report?  In that case you don't put the password in Crystal but in the application.

    I don't think you can store the password in Crystal.

    LVL 42

    Accepted Solution


    I assume you're currently letting Crystal just prompt for a password when the report runs?  If so, simply hardcode the credentials into your application (or pull them from a web.config file if you prefer) and pass them to Crystal through your application.  If you need a code sample for that let us know.


    Author Comment

    Hi, I found code for hardcoding the password in ASP.NET. Thanks!


    Featured Post

    Better Security Awareness With Threat Intelligence

    See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

    Join & Write a Comment

    I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
    There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
    Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…
    how to add IIS SMTP to handle application/Scanner relays into office 365.

    746 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    15 Experts available now in Live!

    Get 1:1 Help Now