I am using Crystal Report for Visual Studio 2010 to develop Crystal Report. In the ASP.NET, I use the code behide to set the database logon credential for Crystal Report.
ReportDocument rpt = new ReportDocument();
rpt.SetDatabaseLogon(conn.UserID, conn.Password, conn.DataSource, conn.InitialCatalog, false);
It is working fine connecting to development database server. However, after I change the database connection to production database server, it show me "Database logon failed.".
How can I do so I can move my crystal report to production smoothly? Thank you.