Help deploying crystal report in visual studios 2008

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.
Who is Participating?
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)
gofferAuthor Commented:
How do I change the connect string at this point?  
gofferAuthor 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.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.