Database logon failed while using mysql azure
<p>I am trying to print crystal report in PDF format , and on my local machine it’s working fine. But when I publish application to the server, it’s giving me the following error on Print button.
<code>Exception Details: System.Runtime.InteropServices.COMException: Database logon failed.</code>
Below is my code in my controller</p>

<pre><code>    public ActionResult Export(int Id)
    {
     ReportDocument rd = new ReportDocument();
     rd.Load(Path.Combine(Server.MapPath("~/Reports/GcReport.rpt")));
     var query = rLAService.GetGeneralConsignmentById(Id);
     var querylist = new List&lt;GeneralConsignmentDto&gt; { query };
     rd.SetDataSource(querylist);
     rd.SetParameterValue("Id", Id);
     //rd.SetDataSource(rLAService.GetGeneralConsignmentById(Id));
     Response.Buffer = false;
     Response.ClearContent();
     Response.ClearHeaders();
     Stream stream = rd.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat);
     stream.Seek(0, SeekOrigin.Begin);
     return File(stream, "application/pdf", "GC Report.pdf");            
    }
</code></pre>

<p>Edit
Ok, after digging throuh the problem, i found that error is <code>table name generalconsignment1</code> does not found. But problem is it is taking automatically instead of <code>generalconsignment</code>.now how to handle this situation?</p>