September 5, 2008 10:43pm pdt

Member Login

Hall of Fame

Yearly

1TheLearn... 181,689
2jaime_oliv... 105,818
3Fernando... 66,427
4jpaulino 65,714
5emoreau 64,500
6Dhaest 63,975
7graye 51,100
8naspinski 38,630
9Idle_Mind 36,589
10angelIII 33,130
11jcoehoorn 27,939
12sachintana 26,000
13ororiole 24,950
14margajet24 22,950
15webtubbs 21,422
16philipjonat... 21,088
17raterus 20,050
18rachitkohli 19,036
19vs1784 18,400
20sjturner2 17,800
21ZachSmith 17,480
22GreenGho... 17,422
23chapmandew 16,640
24mlmcc 15,900
25CMYScott 15,700

	[x] Attachment Details

How To Prevent The Web Application From Asking For SQL SERVER Login Information Each Time??

Zones: Visual Studio 2008, Crystal Reports Software, SQL Server 2005

Tags: Microsoft, Microsoft Visual Studio 2008, 2008, ASP.NET, Microsoft Windows Internet Explorer 7

Greetings Experts!
I hope someone could help, I am kind of stuck with this annoying problem, here it is:

I am MS.SQL Server 2005 installed on my machine, and I have a web application which I am working on, and I needed to add a report on one of the pages, "daily_trans_report.aspx", what I did is I added a "CrystalReportViewer" control on the page, I specified the CrystalReportSource and CrystalReport to be used, the problem is, every time I run the application and try to view the "daily_trans_report.aspx" page I am requested to enter the username and password to access the Database on the SQL SERVER, and I couldn't find a a place in the Visual Studio where I can fix the database login information so that it deosn't keep asking for it each time I run the application.

I have attached the source of the page in the code snippet.
Thanks in advance.
~salman~

         
           
             1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:
27:
28:
29:
30:
31:
32:
33:

           
           
             <%@ Page Language="VB" AutoEventWireup="false" CodeFile="Daily_Trans_Report.aspx.vb" Inherits="Daily_Trans_Report" %>
 
<%@ Register assembly="CrystalDecisions.Web, Version=10.5.3700.0, Culture=neutral, PublicKeyToken=692fbea5521e1304" namespace="CrystalDecisions.Web" tagprefix="CR" %>
 
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
 
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title>Untitled Page</title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
    
        <asp:HyperLink ID="HyperLink1" runat="server" NavigateUrl="~/MainDefault.aspx">'D1,H9 
        'DI 'D5A-) 'D1&J3J)</asp:HyperLink>
        <br />
        <br />
        <br />
        <br />
        <CR:CrystalReportViewer ID="CrystalReportViewer1" runat="server" 
            AutoDataBind="True" Height="793px" ReportSourceID="CrystalReportSource1" 
            Width="1183px" />
        <CR:CrystalReportSource ID="CrystalReportSource1" runat="server">
            <Report FileName="trans_dealy1.rpt">
            </Report>
        </CR:CrystalReportSource>
        <br />
    
    </div>
    </form>
</body>
</html>

           
         

Start your free trial to view this solution

[x]

The Solution Rating System

With so many solutions, how can you tell which solutions are most likely to help you and which ones are not? To provide you with a tool to use, we rate our solutions based on various elements that most accurately determine if a solution is a quality solution. To explain what factors affect the solution rating, here are the elements we take into consideration when formulating our solution rating.

The Grade of the Solution
The Zone Rank of the Expert Providing the Solution
The Number of Author and Expert Comments
The Number of Experts Contributing
The Feedback of the Community

Your Input Matters
Because of the way the system is set up, the most important variable in this equation is you. As a member of Experts Exchange, you are able to cast your vote on the quality of the solutions in regard to how complete, accurate, helpful and easy to understand each solution is. When you provide your feedback, each rating is adjusted accordingly. So, if you see a solution that has a poor rating that you think is a good solution, let us know by rating it. As you do, the rating will be adjusted and will become more accurate for other members of our site.

If you have any suggestions that you would like to make for our rating system, please ask a question in the Suggestions Zone of Community Support.

Thank you!

8.2

Question Stats

Zone: Microsoft

Question Asked By: salman_sulaiman_2008

Solution Provided By: mlmcc

Participating Experts: 2

Solution Grade: A

Translate:

Loading Advertisement...

20080723-EE-VQP-34 / EE_QW_2_20070628