Results 1 to 2 of 2

Thread: Crystal Reports - SQL Security Problem

  1. #1
    Join Date
    Feb 2009
    Location
    Boston, MA USA
    Posts
    745

    Default Crystal Reports - SQL Security Problem

    Hi, I am attempting to roll out a 19.1 VDF application with crystal 11 reports with a SQL backend (first time with this config for me).

    I had initial troubles where my app would run fine on the server, but the workstations did not pass SQL security: I solved this.
    My problem now is that when the app is run on the workstations, the Crystal reports error out on attempting to read the SQL data: It prompts me for a login, and then when I give a valid login/password it still fails.

    Is there a way for my crystal reports (within the vdf code) can authorize/login to SQL?
    PD
    Peter A Donovan
    Applause Software
    Wakefield, MA USA
    (781) 548-9420
    www.ApplauseSoftware.Com

  2. #2
    Join Date
    Feb 2009
    Location
    Round Lake, IL
    Posts
    1,882

    Default Re: Crystal Reports - SQL Security Problem

    We created a SQL User called CrystalUser which has read only access to the table. Then in each report we set the credentials to this CrystalUser account.
    Todd Forsberg
    Idealease, Inc.
    Senior Programmer

    Web and Mobile Development: Think Outside the <DIV>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •