We help IT Professionals succeed at work.

Help deploying crystal report in visual studios 2008

Medium Priority
441 Views
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.
Comment
Watch Question

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)

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts

Author

Commented:
How do I change the connect string at this point?  

Author

Commented:
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.
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.