Solved

When I invoke my Crystal Report from my  ASP .Net (visual Studio 2005 with C#) Application it always prompt me from the password for the SQL Server (2005)

Posted on 2009-04-11
2
300 Views
Last Modified: 2013-11-26
When I invoke my Crystal Report from my  ASP .Net (visual Studio 2005 with C#) Application it always prompt me from the password for the SQL Server (2005) . What do I need to do to avoid this.
Crystal-Report-Screen-Shot.jpg
0
Comment
Question by:tatchis1
2 Comments
 
LVL 5

Accepted Solution

by:
mfhorizon earned 500 total points
ID: 24121997
In Crystal report reset the database connection with USE INTEGRATED SECURITY as "checked". I believe Your SQL Server must be using integrated solution.

I have encountered this problem many times and it solves the problem. Better use OLEDB connection type in report.

Cheers!!
0
 

Author Comment

by:tatchis1
ID: 24122525
This solution help. Thanks.
0

Featured Post

3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

Question has a verified solution.

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

This article describes relatively difficult and non-obvious issues that are likely to arise when creating COM class in Visual Studio and deploying it by professional MSI-authoring tools. It is assumed that the reader is already familiar with the cla…
Many of us here at EE write code. Many of us write exceptional code; just as many of us write exception-prone code. As we all should know, exceptions are a mechanism for handling errors which are typically out of our control. From database errors, t…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…

770 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