Crystal reports how to avoid logon info - ASP.NET web forms

See more:

C#

ASP.NET

WebForms

, +

Hello,
even though I found a lot of articles about Crystal reports and ASP.NET it seems that I can't make it work.
I'm trying to load a crystal report to a web form and I'm getting prompted the logon window even thought I added the connection info to the code as you can see below:

ConnectionInfo myConnectionInfo = new ConnectionInfo();

 myConnectionInfo.ServerName = "server";
 myConnectionInfo.DatabaseName = "DB1";
 myConnectionInfo.UserID = "user";
 myConnectionInfo.Password = "pass";

 ReportDocument cryRpt = new ReportDocument();

 cryRpt.Load(Server.MapPath("~/test.rpt"));

 TableLogOnInfos mytableloginfos = new TableLogOnInfos();
 mytableloginfos = CrystalReportViewer2.LogOnInfo;
 foreach (TableLogOnInfo myTableLogOnInfo in mytableloginfos)
   {
     myTableLogOnInfo.ConnectionInfo = myConnectionInfo;
   }

 CrystalReportViewer2.ReportSource = cryRpt;

Any ideas how to load a report without be asking for login info?

Thank you in advance.

What I have tried:

1. I added the following line but I get the error message "Database logon failed."

CrystalReportViewer2.EnableDatabaseLogonPrompt = false;

2. I added the connection info on CrystalReportViewer2_Init but the problem remains the same.