crystal report login faile error

Question

0.00/5 (No votes)

See more:

I have a problem when crystal report running error
crystal report login failed "username","password"
Notes :
connection string don't have username and password like
cn = new SqlConnection(@"server=localhost; database=Issues; integrated security= true;");

C#

Copy Code

get_all_report myreport2 = new get_all_report();
                               
                myreport2.SetDatabaseLogon("sa", "", "localhost", "Issues", true);
                
                myreport2.SetParameterValue("@fld", "rep_number");
                myreport2.SetParameterValue("@val", textBox2.Text);
                report_view myform = new report_view();
                myform.crystalReportViewer1.ReportSource = myreport2;
                myform.ShowDialog();

Posted 22-Sep-15 10:05am

Member 11538085

Add a Solution

Comments

aarif moh shaikh 23-Sep-15 8:39am

need not to authenticate in window authentication

Member 11538085 23-Sep-15 10:18am

i know but error message login failed

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Member 12003400 · Answer 1 · 2015-09-22T21:25:00

Solution 1

If you connection string is not having credentials meaning it is accessing your windows authentication. So in your above code remove line having myreport2.SetDatabaseLogon or write your windows login id and password rather than "sa".

Permalink

Posted 22-Sep-15 21:25pm

Member 12003400

Comments

Member 11538085 23-Sep-15 10:20am

i don't understand you
i test like this
myreport2.SetDatabaseLogon("", "", "localhost", "Issues", true); the same error

Member 12003400 24-Sep-15 0:53am

Try removing this line. It will work.
OR
myreport2.SetDatabaseLogon("WindowsLoginID", "LoginPAssword", "localhost", "Issues", true);

Member 11538085 24-Sep-15 10:40am

thanks for you
i before remove the line it's work with me in local machine but when i setup the program in the customer appear this error crystal report login failed .
there i think should choose another salutation
if the customer don't have password in local machine and i want my program work without any password what can i do .

Member 12003400 25-Sep-15 1:02am

For that first create one sql user with password. In your connection string also include that userid and password. and then include this line myreport2.SetDatabaseLogon("sqlusername", "userpassword", "sqlservername", "Issues", true);

crystal report login faile error

1 solution

Solution 1

Add your solution here

Preview 0

crystal report login faile error

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us