Help deploying crystal report in visual studios 2008

Posted on 2009-02-13
Last Modified: 2013-11-26
I have built a web applicatoin in VS 2008 with crystal reports.  When I made the reports I selected to use integrated security because the machine I'm developing on is the same machine I'm deploying on.  During development everything worked great, when I would run the project the reports came up without a problem.  Since I have deployed it when I go to the pages with crystal reports on them it says that I have to login to the SQL database.  I don't want the users to have to login each time they look at a report, but I don't know how to change the crystal report to authenticate on it's own.  Can someone please help me?  I'm pretty new at the 'deploying' part of this, and I'm still kind of lost on how all the security for everythign works, so details and explanations would be very helpful.
Question by:goffer
    LVL 9

    Accepted Solution

    You will have to pass the username and password variable you use to login to the database to the connect string when calling the report or put it statically in your code (not recommended)

    Author Comment

    How do I change the connect string at this point?  

    Author Comment

    I'm trying to just re-create the report from scratch and I set it to use SQL server authentication, but now I have a problem even in development.  When I try to run the page with the report on it from visual studios i get an error saying
    "Logon failed. Details: ADO Error Code: 0x Source: Microsoft SQL Native Client Description: Login failed for user '92aspuser38'. SQL State: 28000 Native Error: Error in File C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\2\Keys {E9E98922-EA9F-4B54-A5A5-624A268D39F7}.rpt: Unable to connect: incorrect log on parameters."
    I can't figure out the problem with this either.  I can log in to the SQL management studio using the same user and password and run the store procedure i'm using without any problems.  
    I need help fixing one problem or the other if anyone has any ideas.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Join & Write a Comment

    If I have to fix slow responding website my first thoughts are server side optimizations: the database may not be optimized or caching is not enabled, or things like that. We often overlook another major part of our web application: the client. We o…
    If you don't have the right permissions set for your WordPress location in IIS, you won't be able to perform automatic updates. Here's how to fix the problem.
    This video teaches users how to migrate an existing Wordpress website to a new domain.
    Use Wufoo, an online form creation tool, to make powerful forms. Learn how to choose which pages of your form are visible to your users based on their inputs. The page rules feature provides you with an opportunity to create if:then statements for y…

    754 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

    19 Experts available now in Live!

    Get 1:1 Help Now