Crystal report: Unable to connect: incorrect log on parameters

Question

This is the code of Crystal Report:

    ReportDocument reportDocument = new ReportDocument();
    reportDocument.Load(Server.MapPath(ReportName + ".rpt"));
    reportDocument.SetParameterValue("@userid", Convert.ToInt64(5));
    reportDocument.SetParameterValue("@Reportname", ReportName);
    reportDocument.SetParameterValue("@SessionId", Session.SessionID.ToString());
    CrystalReportViewer1.ReportSource = reportDocument;
    reportDocument.SetDatabaseLogon("sa", "Password1", "192.168.0.245", "databaseName", true);

It is saying "Unable to connect: incorrect log on parameters." although the login information is correct.

If I set the value to "reportDocument.SetDatabaseLogon("sa", "Password1", "192.168.0.240", "databaseName", true);" it is working fine which is the login information was given during the designing the Crystal Report.

Bala R Bala R · Accepted Answer · 2011-02-17T17:29:07

Can try this and see if it helps?

       ConnectionInfo connectionInfo = new ConnectionInfo
                                            {
                                                UserID = user, 
                                                Password = pwd, 
                                                ServerName = server, 
                                                DatabaseName = db
                                            };
        TableLogOnInfo tableLogOnInfo = new TableLogOnInfo
                                            {
                                                ConnectionInfo = connectionInfo
                                            };
        foreach (Table table in reportDocument.Database.Tables)
        {
            table.ApplyLogOnInfo(tableLogOnInfo);
        }

Crystal report: Unable to connect: incorrect log on parameters

2 Answers