[RESOLVED] Crytal report logon failed

[usamaalam]

Hello Everybody,

My application is developed with VS 2005 and crystal reports 10. It works fine on my local machine but when I try to run the app on the server where I deployed it, it uses the design time login credentials and hence doesn't allow me to see the report and throws following exception on the report page.

Logon failed. Details: ADO Error Code: 0x Source: Microsoft OLE DB Provider for SQL Server Description: Login failed for user 'sa'. SQL State: 42000 Native Error: Error in File C:\WINDOWS\TEMP\AlphaListing {1C4A8624-64C0-4721-B98D-68CC729163CE}.rpt: Unable to connect: incorrect log on parameters.

I am passing log on parameters using code and the username is not 'sa' which crystal report is trying to connect with. Here's the code as to how I am trying to show the report.

                CrystalDecisions.CrystalReports.Engine.ReportDocument reportDoc = new CrystalDecisions.CrystalReports.Engine.ReportDocument();

                string serverName = Sterling.JIDB.BusinessLogicLayer.DatabaseInfo.GetServerName();
                string databaseName = Sterling.JIDB.BusinessLogicLayer.DatabaseInfo.GetDatabaseName();
                string userName = Sterling.JIDB.BusinessLogicLayer.DatabaseInfo.GetUserName();
                string password = Sterling.JIDB.BusinessLogicLayer.DatabaseInfo.GetPassword();

                Response.Write(userName + "--" + password + "--" + databaseName + "--" + serverName);

                reportDoc.Load(Server.MapPath("AlphaListing.rpt"));
                reportDoc.Refresh();

                reportDoc.SetDatabaseLogon(userName, password, databaseName, databaseName, true);
                reportDoc.Refresh();
                //reportDoc.SetDatabaseLogon(userName, password, databaseName, databaseName, true);

                rptAlphaListing.ReportSource = reportDoc;
                
                reportDoc = null;

Any ideas??

Thanks.

[Besoup]

yeah I think you need to loop through your tables like the code in this thread:

http://www.vbforums.com/showthread.php?t=519097

[usamaalam]

Yes, I looped through all the tables and it works.

Thanks.