Populate Report with Data Reader

What is the proper way to populate a crystal report using a SqlDataReader?  It seems simple enough to do so by simply using rpt.SetDataSource(rdr), but this doesn't appear to work for me.  When executing the following code on my development machine it works perfectly.  However when executing it on a production machine it gives the following error that says "login falied".  Can anyone see what I am doing wrong?


CrystalDecisions.CrystalReports.Engine.ReportDocument rpt = new CrystalDecisions.CrystalReports.Engine.ReportDocument();
                                    
rpt.Load(rptfile);

SqlConnection conReport = new SqlConnection(SOLIMPMODULES.ImportSQL.strConn);
SqlCommand cmdReport = new SqlCommand(strReportSrc, conReport);
cmdReport.CommandType = CommandType.StoredProcedure;

conReport.Open();

SqlDataReader rdr = cmdReport.ExecuteReader();

rpt.SetDataSource(rdr);

foreach(CrystalDecisions.CrystalReports.Engine.Table tbl in rpt.Database.Tables)
{
      tbl.SetDataSource(rdr);
}

rpt.Refresh();

CrystalDecisions.Shared.DiskFileDestinationOptions dopt = new CrystalDecisions.Shared.DiskFileDestinationOptions();

dopt.DiskFileName = strPDFName;

rpt.ExportOptions.ExportDestinationType = CrystalDecisions.Shared.ExportDestinationType.DiskFile;
rpt.ExportOptions.ExportFormatType = CrystalDecisions.Shared.ExportFormatType.PortableDocFormat;
rpt.ExportOptions.DestinationOptions = dopt;

rpt.Export();