Unable to generate report in development server

See more:

C#

"Logon failed. Details: [Database Vendor Code: -2147217887 ] Failed to export the report. Error in File RptQuotationSlip {825EDEC6-A451-4ED8-AD47-BF09268A547F}.rpt: Unable to connect: incorrect log on parameters. Details: [Database Vendor Code: -2147217887 ]"

When I click on generate report button in my application generating crystal report. The report is generating in local host(working fine) but when same application copied to development server system unable to generate report. I got the error message as I mention above in bold letters.

Please help me on this problem.


Advance Thank You.


Here is my code :

strPath = "../Reports/RptQuotationSlip.rpt";
            rptDoc = new ReportDocument();
            rptDoc.Load(Server.MapPath(strPath));

            string strServerName = ConfigurationManager.AppSettings["RptServerName"].ToString();
            string strDatabaseName = ConfigurationManager.AppSettings["RptDBName"].ToString();
            string strPassword = ConfigurationManager.AppSettings["RptPassword"].ToString();
            string strUserID = ConfigurationManager.AppSettings["RptUserID"].ToString();
            rptDoc.SetDatabaseLogon(strUserID, strPassword, strServerName, strDatabaseName);

            rptDoc.SetParameterValue("@1_QuoNo", QuoteID);
            rptDoc.SetParameterValue("@1_AgentName", strAgentName);
            rptDoc.SetParameterValue("@1_AgentTelNo", strAgentTelNo);
            rptDoc.SetParameterValue("@1_QuoNo", QuoteID, "RptNCDValues");
            rptDoc.SetParameterValue("@1_QuoNo", QuoteID, "RptExtraCoverageDtls");
            rptDoc.SetParameterValue("@1_QuoNo", QuoteID, "RptExtraCoverNote");

            objStr = (System.IO.MemoryStream)rptDoc.ExportToStream(ExportFormatType.PortableDocFormat);//I am getting error here.

            Response.Clear();
            Response.Buffer = true;
            Response.ContentType = "application/pdf";
            Response.BinaryWrite(objStr.ToArray());
            rptDoc.Refresh();
            Response.Flush();
            Response.Close();