asked on

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.

ASKER CERTIFIED SOLUTION

crawfordits

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

goffer

ASKER

How do I change the connect string at this point?

goffer

ASKER

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.