[Last Call] Learn how to a build a cloud-first strategyRegister Now


Help deploying crystal report in visual studios 2008

Posted on 2009-02-13
Medium Priority
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
  • 2

Accepted Solution

crawfordits earned 2000 total points
ID: 23638331
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

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

Author Comment

ID: 23638696
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

[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article shows how to deploy dynamic backgrounds to computers depending on the aspect ratio of display
Without even knowing it, most of us are using web applications on a daily basis.  In fact, Gmail and Yahoo email, Twitter, Facebook, and eBay are used by most of us daily—and they are web applications. We generally confuse these web applications to…
This video teaches viewers how to create their own website using cPanel and Wordpress. Tutorial walks users through how to set up their own domain name from tools like Domain Registrar, Hosting Account, and Wordpress. More specifically, the order in…
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…
Suggested Courses
Course of the Month18 days, 2 hours left to enroll

830 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